I'm using the following macro to split my spreadsheet into separate worksheets based on column 5. I need to modify the macro to split into separate spreadsheets instead of worksheets within one file.
At the top of each worksheet I need the format and formulas to carry over - so for Dave Williams worksheet I'd want it to calculate his budget by totalling the correct fields.
I also need the formulas within the spreadsheet to carry over from the original.
Lastly, I need to protect the spreadsheets so that they can only edit columns AD, AJ and AM.
I have been able to modify this to copy over the top section to each sheet, but not the rest of the requirements.
As always, any help is much appreciated!
-----------------------------------
Bookmarks