Update existing macro that splits a list into worksheets to split into templates instead

Hi,

I hope the above subject isn't too confusing.

I have managed to find and doctor a code that splits a long list into account specific lists in their own worksheets that are named as the unique entry - account number. My problem now is that instead of opening the default blank worksheet for each accounts worksheet, I would like to open a saved template so that each worksheet contains formula to manipulate the data and is formatted with font/colour etc.

I have tried amending the code I have with another code to open templates (the open template code works fine by itself) but am getting error messages.

has anybody got any ideas how I can do this?

this is my first post on here- hope I have pasted the code so you can read it ok.

Thanks,
Graeme

Please Login or Register  to view this content.