Hi,

I have attached a simplified version of a sheet i am working on and i wonder if someone can help.

I have very little experience of writing macros and while i can do everything else using the "record macro" function i am struggling to create a "loop".

I need a macro that does the following:
Changes cell A6(CAR SALES sheet) to a value (from the list, validated by the values in the DEFINITIONS sheet)

Calculates the formulas in B6:N6(CAR SALES sheet) as these are dependant on A6

Copies the whole sheet to a new sheet in the same workbook, pasting values to remove the formulas

Re-name the new sheet the same as the value in A6

Work through the next value in the list in the cell A6 and repeat

Thanks for any help, i've found this impossible to do so far!
Main workbook (template for macro) v3.xlsm