Merging excel spreadsheets

  • Thread starter Thread starter DarrenWood
  • Start date Start date
D

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
 
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
 
Thanks for your suggestions, I have never used macros before but this
has encouraged me to try and with great success,

Thank you
 
Back
Top