youngatheart
New Member
- Joined
- Apr 30, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi,
I need help in consolidating from multiple workbooks into one,
- Source Data - Starts from Row A5 to AC5 until 2nd to the last column *last column of the data is not needed*
- Master data - header is at Row 2, Paste data starting on Column B, now I need to identify the copied data in column A "Batch" on which batch it came from stating 1 if from first source data and so forth
I usually do this manually but data is thousands of rows to copy from 5-10 workbooks to one.
Hope you can help me on this to make this more efficient.
I need help in consolidating from multiple workbooks into one,
- Source Data - Starts from Row A5 to AC5 until 2nd to the last column *last column of the data is not needed*
- Master data - header is at Row 2, Paste data starting on Column B, now I need to identify the copied data in column A "Batch" on which batch it came from stating 1 if from first source data and so forth
I usually do this manually but data is thousands of rows to copy from 5-10 workbooks to one.
Hope you can help me on this to make this more efficient.