Previous Topic Next Topic

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response