Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To consolidate contents of multiple workbook
Hi,
We are using one main workbook which contains 4 or 5 worksheets.The main work book has a sheet called EBD. This worksheet is also persent in 6 other workbooks available to different managers at a shared location. The managers would make changes to two columns of this worksheet i.e 'EBD' in their respective workbooks the entire day. At 5.00 p.m we want the access of the manager is disabled for each of their workbooks and we want to consolidate all the changes in the 6 workbooks and update the 'EBD' sheet of the main workbook. Can anyone tell me how can I consolidate the information that all managers update during the day and later on run a macro at 5.00 pm automatically, diasble their authorization and than consolidate all in the main. Thanks a lot. Thanks and Regards, Shal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate Worksheet Contents | Excel Worksheet Functions | |||
How do I consolidate multiple worksheet files into one workbook | Excel Discussion (Misc queries) | |||
Consolidate multiple worksheets in a workbook into one | Excel Discussion (Misc queries) | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
Consolidate workbook sheets to another workbook sheet | Excel Programming |