Varible column (a,b,c etc) within a formula

[Closed]
Report
Posts
1
Registration date
Friday November 29, 2013
Status
Member
Last seen
November 29, 2013
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
I have a sheet 1 with raw data inserted. Each Sheet 2,3,4 within the same workbook has another spreadsheet that needs to read the raw data from sheet 1 from a particular column. I would like to have a formula like =sheet1!d30 which would be inserted in sheet 2,3,4 etc. where the column is a variable meaning Sheet 2 would use column D data and Sheet 3 would use column F etc.
Very new to Excell.
Would love some help.

1 reply

Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi Rhead78,

Not sure with what you need help with.

For sheet2 use =sheet1!d30 and for sheet3 use =sheet1!f30.

Could you explain again?

Best regards,
Trowa