lietuvis91
New Member
- Joined
- Nov 14, 2005
- Messages
- 8
hey all,
I have a workbook w/ 278 worksheets in it and was asked to separate the worksheets into individual workbooks. I can drag and drop each one until my hand falls off, or maybe someone here knows a better way to automate this. Each new workbook should be named after the worksheet it's created from. I'm not afraid to tamper with code, so all suggestions welcome.
I have a workbook w/ 278 worksheets in it and was asked to separate the worksheets into individual workbooks. I can drag and drop each one until my hand falls off, or maybe someone here knows a better way to automate this. Each new workbook should be named after the worksheet it's created from. I'm not afraid to tamper with code, so all suggestions welcome.