andysweeney
New Member
- Joined
- Mar 8, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
HI all,
Struggling on this one despite seeing answers for some similar things.
I need some VBA to copy the data from Row 2 until the last populated row from every workbook in a designated folder into a single worksheet. The main issue that I have with previous answers is that the worksheets within any workbook are all named differently. (ie. not called "Sheet1")
Any help appreciated!
Andy
Struggling on this one despite seeing answers for some similar things.
I need some VBA to copy the data from Row 2 until the last populated row from every workbook in a designated folder into a single worksheet. The main issue that I have with previous answers is that the worksheets within any workbook are all named differently. (ie. not called "Sheet1")
Any help appreciated!
Andy