HELP !!!!!!!!

[Stormseed]

Dear friends...

I wanna merge all the rows (rows with data) in around 100 different excel sheets (around 100 sheets) into one sheet...kindly let me know if there is a way in VBA !

Please Please if someone helps with the code....would appreciate the same !

Thanks people

 

[acw]

Hi

Did a quick search on Merge and came up with a few options. Here's one.


http://www.mrexcel.com/board2/viewtopic.php?t=223954&highlight=merge+sheets


HTH

Tony

 

[Stormseed]

hey...this webpage is cool...appreciate your help mate ! Neverthless...I got the solution for my problem