Merging excel workbooks into one main worksheet
 

I have a master spreadsheet which is pre-populated with data (Columns A -
AP). People will be sending their data to me via a spreadsheet and I need to
have all the new data added into the master file so that I have one
spreadsheet. Fields in which new data could have been added or corrected
that need to be transferred to the master file include:
Columns N & O
Columns S €“ Z
Columns AB
Add any new names to be populated in Columns A, B & C. This also will be
shared and used by other members in my team when I am out of the office. Is
there any way of including Control buttons.

Thanks

Merging excel workbooks into one main worksheet
 

Try this add -in
http://www.rondebruin.nl/merge.htm

Or the code if you want from my site

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"vlwilburn" wrote in message ...
I have a master spreadsheet which is pre-populated with data (Columns A -
AP). People will be sending their data to me via a spreadsheet and I need to
have all the new data added into the master file so that I have one
spreadsheet. Fields in which new data could have been added or corrected
that need to be transferred to the master file include:
Columns N & O
Columns S €“ Z
Columns AB
Add any new names to be populated in Columns A, B & C. This also will be
shared and used by other members in my team when I am out of the office. Is
there any way of including Control buttons.

Thanks