Hi all, I hope someone can help. I have a spreadsheet with a row of weeks for 7 years - so 52 x 7 columns. I am looking for some code that will generated named ranges for the Sales row below for each year e.g. SalesYear1, SalesYear2....... I would also like it to be sufficiently flexible for me to create further code for the next row, say ExpensesYear1, ExpensesYear2.....

Any help would be much appreciated.

Cheers,
Andrew