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

Closed
rhead78 Posts 1 Registration date Friday 29 November 2013 Status Member Last seen 29 November 2013 - 29 Nov 2013 à 14:48
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Dec 2013 à 10:20
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
5 Dec 2013 à 10:20
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