Hi all,
I have a current workbookCopy of ASP Test RC File.xlsx with 3 worksheets.
Worksheet RC is a summary of all companies rates (Columns G:J). I've shortened this to keep the file small but in reality there are actually another 140 columns after Column G.
What I am looking to do is create an individual file for each Company i.e. each column from G onwards yet keep Columns A:F as these will be the same for all.
Furthermore, I would like each new file contain the Instructions and Cover Page tabs (Sheet 1 & 2).
Each new file should be renamed according to the name listed in G5, G6, G7, etc...
Is there a way to do this with VBA to save me manually having to create 140+ plus files and copying and pasting sheets 1 & 2 into each file?
Any assistance would be greatly appreciated.
Kind regards,
Bookmarks