Hi Kiran
I get an error 1004 , cannot rename the sheet samas another one, on the following line.
I know this may be too silly to ask on this forum, can you send me your mail id to help me thorough with this macro.
I am planning join the VBA course soon.
x.Name = "Consolidated"
Regards...
Thank you Kiran. Hope you enjoyed the movie...
I will try this and report back with further questions, which I am sure I will have.
I am not so familiar with VBA rouintes, to start with it will be helpful it will be helpful if you can mark the lines or values I should modify as per my ws...
Friends
I have few excel files containg stocks filtered based on difrent conditions. i would like like to locate and make a new file containing stock names appearing in diffrent sheets and no of occurances.
Your help will be very much appreciated
Thanks & Regards
Vijay