Hi,
I have an xlsb workbook. I have a cell with the value 1 in it. Adjacent to it I have a cell with the Named Range “Club_name” – this cell uses the 1 as the row number in an INDEX function to lookup a name from a list. I have another Named Range called “Data” which also updates when the 1 changes.
I want to make 100 copies of my original workbook. I want to loop through the numbers 1-100, hard-pasting the Named Range “Data” and each time save it as a new workbook (using the Named Range “Club_name” as the filename) in the xlsx format. Note, presumably each time the original workbook needs to be used in the code to loop through the numbers and so that the Named Range “Data” updates (i.e. before it is hard-pasted).
Anyone able to help. I’ve been trying but getting nowhere
Thanks
I have an xlsb workbook. I have a cell with the value 1 in it. Adjacent to it I have a cell with the Named Range “Club_name” – this cell uses the 1 as the row number in an INDEX function to lookup a name from a list. I have another Named Range called “Data” which also updates when the 1 changes.
I want to make 100 copies of my original workbook. I want to loop through the numbers 1-100, hard-pasting the Named Range “Data” and each time save it as a new workbook (using the Named Range “Club_name” as the filename) in the xlsx format. Note, presumably each time the original workbook needs to be used in the code to loop through the numbers and so that the Named Range “Data” updates (i.e. before it is hard-pasted).
Anyone able to help. I’ve been trying but getting nowhere
Thanks
