Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing other worksheets in a main worksheet | Excel Discussion (Misc queries) | |||
Merging identical workbooks in Excel 2007 | Excel Discussion (Misc queries) | |||
Merging Workbooks to give one Excel Doc with all info. | Excel Discussion (Misc queries) | |||
on your main page click on the worksheet name and be taken to it | Excel Worksheet Functions | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions |