I have a list of names in column A on a sheet, 'Master'. I then have a 'Template' sheet that has formulas that reference other columns in the same row. Ex. On 'Master', A2= Doe, Jon, B2=100, D2=230, F2=130, H2=250. Then on the template I have multiple formulas, but each referring to a specific cell. Ex. On 'Template' C9=CEILING(0.65*Master!$B2,5), H9=CEILING(0.65*Master!$D2,5), C20=CEILING(0.65*Master!$F2,5), H20=CEILING(0.65*Master!$H2,5). There are more formulas but they all refer to those 4 cells on row two with the numbers for Doe, Jon. I need to create multiple duplicates for each name in Column A on 'Master' but I want the formulas to adjust to the same row. So if A3=Doe, Jane I need a new sheet named Doe, Jane with the same formulas but changed to the next row Ex. from 'Template' C9=CEILING(0.65*Master!$B3,5), H9=CEILING(0.65*Master!$D3,5), C20=CEILING(0.65*Master!$F3,5), H20=CEILING(0.65*Master!$H3,5).
I would prefer to have a formula that would do it in real time so if I add names to the list it would automatically create a new sheet, but I don't know if that's possible. I have a code to create the sheets based on the list of names but I'd still need to change the formulas for each sheet manually.
I would prefer to have a formula that would do it in real time so if I add names to the list it would automatically create a new sheet, but I don't know if that's possible. I have a code to create the sheets based on the list of names but I'd still need to change the formulas for each sheet manually.