Dunk4Divin
New Member
- Joined
- Aug 21, 2019
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hi
I have a workbook which currently has 60+ sheets. Some of these are generated by copying the format from a "master" form and creating a series of work instructions for which the Tabs are named "Gauge Instruction (X)". The suffix is the normal excel generated number. What I need to be able to do is select all sheets with the words "Gauge Instruction" without the suffix and then:
1 Print hard copies
2 Export to a new workbook
3 Export as PDFs.
Any assistance will be greatly appreciated.
Thanks
I have a workbook which currently has 60+ sheets. Some of these are generated by copying the format from a "master" form and creating a series of work instructions for which the Tabs are named "Gauge Instruction (X)". The suffix is the normal excel generated number. What I need to be able to do is select all sheets with the words "Gauge Instruction" without the suffix and then:
1 Print hard copies
2 Export to a new workbook
3 Export as PDFs.
Any assistance will be greatly appreciated.
Thanks