Hi
I have a spreadsheet that i would like to input the same formula but across every worksheet i have.
I have one master spreadsheet which has 38 columns per person and then 38 separate worksheets.
I want to be able to input the value of the same cell from these worksheets in each of the 38 columns without having to amend the formula manually to change the sheet name etc?
Help Appreciated
Jordan
I have a spreadsheet that i would like to input the same formula but across every worksheet i have.
I have one master spreadsheet which has 38 columns per person and then 38 separate worksheets.
I want to be able to input the value of the same cell from these worksheets in each of the 38 columns without having to amend the formula manually to change the sheet name etc?
Help Appreciated
Jordan