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