Combining data from 6 workbooks into one master
 

Please can you help with this.

I have 6 workbooks with one sheet in each that is identical - with text data
in

I need to design a 'master' sheet that when one is updated so is the master.

The amount of rows will differ for each sheet but the column names are the
same in the same place.

Thanks is advance

Combining data from 6 workbooks into one master
 

Check out Ron's site, especially the section about halfway down dealing with
Copy/Paste/Merge.
http://www.rondebruin.nl/tips.htm

He has several ways of combining multiple sheets and/or workbooks into a a
summary workbook/worksheet/csv file.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"natty2506" wrote:

Please can you help with this.

I have 6 workbooks with one sheet in each that is identical - with text data
in

I need to design a 'master' sheet that when one is updated so is the master.

The amount of rows will differ for each sheet but the column names are the
same in the same place.

Thanks is advance