$$Excel-Macros$$ Re: NSEINDIA Stock Price change Automatically

2012-12-31 Thread amar takale
Can anybody help me pls On Fri, Dec 28, 2012 at 4:26 PM, amar takale wrote: > Dear Experts team, > > > A humble request with experts to provide me a solution or guide me how to > extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from > nseindia website.If Share market are open

Re: $$Excel-Macros$$ happy new year

2012-12-31 Thread johnson john
thanks!!! I wish you all a great pleasure of learning EXCEL in 2013. Its so cool. regards., Johnson FCA On Tue, Jan 1, 2013 at 10:58 AM, excel lerner wrote: > I wish You a very happy New Year to all Grou Members > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/d

$$Excel-Macros$$ happy new year

2012-12-31 Thread excel lerner
I wish You a very happy New Year to all Grou Members -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advi

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

2012-12-31 Thread Cab Boose
Thnkyou Guys for the codes. The code that Anoop sen t works very well, and I will go with that. Thanks for your help Lalit and Anoop Regards Charlie On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma wrote: > Please try the below one. > > Sub PasteValueOnly() > Dim rng As Range > Set rng

Re: $$Excel-Macros$$ How to extract sheet from many excel sheets

2012-12-31 Thread Anoop K Sharma
Better to make another copy of workbook bcoz somehow you are asking the same thing. On Mon, Dec 31, 2012 at 1:01 PM, maulik desai wrote: > Hi team, > I am having 1excel workbook which contains 250 excel sheets and now I want > to extract those sheets into separate workbook for each sheets. Means

Re: $$Excel-Macros$$ Fwd: Hepl Required

2012-12-31 Thread Prajakt Pande
Dear Neeraj Chauhan, Please check and reply. It solved. file attached Thanks & Regards, Prajakt Pande +971551388482 ** On Mon, Dec 31, 2012 at 1:20 PM, neeraj chauhan wrote: > > > On Sat, Dec 29, 2012 at 9:49 PM, >>Excel Beginner<< < > excelbegin...@gmail.com> wrote: > >> Hi Neeraj, >> >>

$$Excel-Macros$$ Re: Happy New Year To All My Friends

2012-12-31 Thread Lalit Mohan Pandey
*Same to you prince and Happy new year to all group members. May all your dreams come true in this year.* Regards, Lalit Mohan On Monday, 31 December 2012 17:26:31 UTC+5:30, Prince wrote: > > *Happy New Year To All.* > * > * > *May God bless you a very nice new year ahead. > * > * > * > * > * >

$$Excel-Macros$$ Happy New Year To All My Friends

2012-12-31 Thread Prince
*Happy New Year To All.* * * *May God bless you a very nice new year ahead. * * * * * *Regards* *Prince* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Re: Loop for changing colour

2012-12-31 Thread Lalit Mohan Pandey
Hi Black, Did you find the solution is helpful. Regards, Lalit Mohan On Monday, 31 December 2012 10:18:25 UTC+5:30, black panther wrote: > > Dear Prince, > > No same color, any color but light color, > > What i am looking for:- > > if cell A1 having yellow & B1 having blue then > > for 1500 time

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-31 Thread Lalit Mohan Pandey
Hi Rashid, Sorry i can't upload file so please follow the given steps: *Step 1:- First create a sample sheet for output report with all the formatting and formula and please make sure it should be for 31 rows as* *max day in a month is 31.* *Step 2:- Press Alt + F11 and Alt + I + M and p

Re: $$Excel-Macros$$ Fwd: Hepl Required

2012-12-31 Thread neeraj chauhan
On Sat, Dec 29, 2012 at 9:49 PM, >>Excel Beginner<< wrote: > Hi Neeraj, > > Pls check attachment. > > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan < > neerajchauhan...@gmail.com> wrote: > >> DEAR Experts, >> >> i am waiting for

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-31 Thread Kenil Gala
Thanks dhaval,but how do i use in my project file.can i import all this data in my same project sheet?and i want to import it automatically by changing date and nse symbol in my excel sheet itself.is that also can be done ?? --- On Mon, 12/31/12, Dhaval Shah wrote: From: Dhaval Shah Subject:

Re: $$Excel-Macros$$ How to remove error" To many different cell formats" in excel

2012-12-31 Thread NOORAIN ANSARI
Dear Maulik, Can you share your sample sheet with group. On Mon, Dec 31, 2012 at 1:05 PM, maulik desai wrote: > Hi team, > I am having 1 excel sheet which shows me error like " to many diff cell > format" while opening the file > . Can. Someone provide me the Solution for this. > > -- > Join off

$$Excel-Macros$$ Re: Sheets name change as per the main list column A

2012-12-31 Thread Prince
Hi Rajesh, I guess there is no way to change the name of sheet through formula.But yes your query very much possible through VBA Macro. Regards Prince On Monday, December 31, 2012 1:17:56 PM UTC+5:30, rajeyssh wrote: > > Dear Sir > if I put column b or column c list in column a all the sheets

$$Excel-Macros$$ Re: How to extract sheet from many excel sheets

2012-12-31 Thread Prince
Hi Maulik, Please cut and paste this code.I hpe this may be helfull for you. Sub CreatWorkbook() Dim wks As Worksheet Dim wbk As Workbook Dim intCtr As Integer intCtr = 1 For Each wks In ThisWorkbook.Worksheets If wks.Name <> "test" Then Set w

$$Excel-Macros$$ Re: How to remove error" To many different cell formats" in excel

2012-12-31 Thread Prince
Hi Maulik, Please share your workbook. Regards Prince On Monday, December 31, 2012 1:05:37 PM UTC+5:30, maulik wrote: > > Hi team, > I am having 1 excel sheet which shows me error like " to many diff cell > format" while opening the file > . Can. Someone provide me the Solution for this. > --