macro to copy data to master workbook.

[sharmashanu]

Hi All

I have 50 workbook in a folder, say wb1, wb2 ...wb50. Every sheet1 of
each workbook has some data in first say 20 lines.
What iam trying to do is run a macro in a master sheet, that will copy
the data of each sheet1,one below the other and also add a column
telling me the wb it is coming from. Look example below.

data............ wb1.xls
sub wb1.xls
date etc wb1.xls

data............ wb2.xls
sub wb2.xls
date etc wb2.xls

data............ wb3.xls
sub wb3.xls
date etc wb3.xls

Any help with the macro would be of great help. All the workbooks are
in same folder.

thanks

Shanu

 

[Mike]

Hello Shanu
Check out this site
http://www.rondebruin.nl/copy3.htm

Good luck

 

[sharmashanu]

Hi Mike,

Thanks alot. I had to massage it very little and it worked gr8.

Thanks for the link

Shanu