Same Formula via multiple sheets

[jhynes89]

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

 

[BarryL]

Joe4's formula should work if input and maintained properly. Add a file to dropbox and post the link or pm me and mail it to me and I'll have a look.

 

[jhynes89]

cant get access to any file sharing whilst at work is email ok?

cheers pal

 

[BarryL]

PM sent