BILLYBOB1972
New Member
- Joined
- Jan 7, 2016
- Messages
- 24
- Office Version
- 2016
- Platform
- Windows
I have a master workbook which copies information from other workbooks. The macro I have opens the source document and pastes information from different worksheets into the master. The issue I have is the source workbooks do not always have all the worksheets so when I open the workbook I need to check if all the proposed worksheets exist before I copy the data and paste. Is there anyway of checking and if the sheet does not exist then do not try and copy the data.
Any help greatly appreciated.
Any help greatly appreciated.