Merging excel spreadsheets

[DarrenWood]

On a weekly basis a receive 7 spreadsheets from different people with
their own set of data ( all numbers ) and all sheets are in the same
format.

Is there anyway in which on receipt i can take this data off the sheet
and import it into my own summary sheet in excel.

Any advice very welcome

Thank you

Darren

 

[Don Guillett]

You can use a for/each loop by opening each and copying the data to the next
available line on your summmary sheet. Record a macro while doing it
manually to get the idea. To get the last row use something like
lastrow=sheets("summarysheet").cells(rows.count,1).end(xlup).row+1

 

[Ron de Bruin]

Hi DarrenWood

I have code examples on my site to do this
http://www.rondebruin.nl/tips.htm

 

[DarrenWood]

Thanks for your suggestions, I have never used macros before but this
has encouraged me to try and with great success,

Thank you