tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,197
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
i need a macro that can open all documents in a folder, and copy sheet2
the problems are this
it needs to be sheet2 not sheets("sheet2") if you know what i mean,
also there are quite a few rows in each sheet so coping to one sheet might not work so i need a way to say if threes not enough room select next sheet.
I have a document to copy into with the standard sheet names so sheet1 sheet2 up to sheet8 which will be more than enough.
please help if you can
Thanks
Tony
i need a macro that can open all documents in a folder, and copy sheet2
the problems are this
it needs to be sheet2 not sheets("sheet2") if you know what i mean,
also there are quite a few rows in each sheet so coping to one sheet might not work so i need a way to say if threes not enough room select next sheet.
I have a document to copy into with the standard sheet names so sheet1 sheet2 up to sheet8 which will be more than enough.
please help if you can
Thanks
Tony