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

Closed
rhead78 Posts 1 Registration date Friday November 29, 2013 Status Member Last seen November 29, 2013 - Nov 29, 2013 at 02:48 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 5, 2013 at 10:20 AM
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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 5, 2013 at 10:20 AM
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