ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Update master workbook from individual workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/72099-update-master-workbook-individual-workbooks.html)

Annabelle

Update master workbook from individual workbooks
 
I have four users who update their own rows of data in a separate
workbook; each workbook layout is identical (columns are the same).
They are using separate workbooks because they need to be in and out of
the spreadsheet all day long and using a shared workbook only allows
one person at a time to enter and save their data.

I need to roll-up all rows into a master workbook that ALL users can
view. Understanding all workbooks will be on the same network drive, is
there a macro that will roll these workbooks into the master?



All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com