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,