Adnandos
New member
- Joined
- Jun 12, 2018
- Messages
- 25
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hi all -not sure exactly where to post this.
I have 20 workbooks that is prepared by 20 different users monthly.
In each workbook there are 5 worksheet tabs, each "clean" workbook is identical in every sense, layout, structure etc.
Meaning worksheet 3 in workbook 1 is identical to worksheet 3 in workbook 2 etc. The users capture data into each worksheet into the respective columns.
At the end of each month I literally open a "clean consolidated" workbook, and begin opening each worksheet in each completed workbook and manually copy it into the consolidated workbook.
There must be a faster way of doing this (macro, vba, something else?) if the relevant workbooks are all stored in the same folder?
If there is, please share how this could be done.
Would really appreciate any assistance, and like I said, not sure where this should have been posted.
I have 20 workbooks that is prepared by 20 different users monthly.
In each workbook there are 5 worksheet tabs, each "clean" workbook is identical in every sense, layout, structure etc.
Meaning worksheet 3 in workbook 1 is identical to worksheet 3 in workbook 2 etc. The users capture data into each worksheet into the respective columns.
At the end of each month I literally open a "clean consolidated" workbook, and begin opening each worksheet in each completed workbook and manually copy it into the consolidated workbook.
There must be a faster way of doing this (macro, vba, something else?) if the relevant workbooks are all stored in the same folder?
If there is, please share how this could be done.
Would really appreciate any assistance, and like I said, not sure where this should have been posted.