| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy 10 workbooks to a combined workbook
I have 10 employees who keep data in their own workbooks. I would like to
have a workbook that contains all 10 workbooks in a master workbook that updates every time they update their individual workbooks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy 10 workbooks to a combined workbook
Using a macro is maybe easier
You can try this add-in if you need to collect the data http://www.rondebruin.nl/merge.htm Or see the links to the code examples on that page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Phil" wrote in message ... I have 10 employees who keep data in their own workbooks. I would like to have a workbook that contains all 10 workbooks in a master workbook that updates every time they update their individual workbooks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to copy many workbooks into 1 workbook | Excel Discussion (Misc queries) | |||
| HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS | Excel Discussion (Misc queries) | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| copy selected tabs from multiple workbooks to a new workbook | Excel Worksheet Functions | |||
| Can Multi WorkBooks Be combined in One Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
