I would like to create multiple copies of a sheet in a workbook, and each sheet will have a particular cell that changes according to a column in a separate sheet.
For example, sheet 1 contains data in the range A1:A5
Sheet 2 contains completely separate and fixed information. However, in sheet 2, Cell B2='Sheet 1'!A1
I would like to create sheets 3,4,5,6,7,8 which are exactly the same as sheet 2, except that B2=A2 in sheet 3, B2=A3 in sheet 4, ect.
I know how to create duplicate sheets, but i do not know how to write the code to change the formula B2='Sheet 1'!A1 to B2='Sheet 1'!An+1 starting from n=1.
Any ideas?
Thanks.
For example, sheet 1 contains data in the range A1:A5
Sheet 2 contains completely separate and fixed information. However, in sheet 2, Cell B2='Sheet 1'!A1
I would like to create sheets 3,4,5,6,7,8 which are exactly the same as sheet 2, except that B2=A2 in sheet 3, B2=A3 in sheet 4, ect.
I know how to create duplicate sheets, but i do not know how to write the code to change the formula B2='Sheet 1'!A1 to B2='Sheet 1'!An+1 starting from n=1.
Any ideas?
Thanks.