C
cardfan3206
I have been using the following code to split an excel file into multiple
workbooks.
http://www.rondebruin.nl/copy5_3.htm
It works great but I want to see if I can get it to do a couple additional
things.
1. I have a series of header rows that I would like to copy to each workbook
that is created.
2. I have 2 worksheets in the master workbook that I would like to copy into
each new workbook.
3. I have done some custom formatting and embedded some formulae that I
would like to copy instead of pasting values only.
Is this doable?
Tracey
workbooks.
http://www.rondebruin.nl/copy5_3.htm
It works great but I want to see if I can get it to do a couple additional
things.
1. I have a series of header rows that I would like to copy to each workbook
that is created.
2. I have 2 worksheets in the master workbook that I would like to copy into
each new workbook.
3. I have done some custom formatting and embedded some formulae that I
would like to copy instead of pasting values only.
Is this doable?
Tracey