Formula References

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys I am really having a hard time here.

On a sheet named Template, I have a number in cell K10. (This number is
currently 7 but can change). Ive got a sheet called Customer Records and
the values I need to reference are in ROW B on that sheet, therefore I need
to create a formula that will create yet another formula that will pull
values from ROW B in cell 7 off of sheet Customer Records. The formula
would be ='Customer Records'!B7. I need for this formula to be inserted in
cell A12 on the current sheet called Template.


Thanx in advance

Todd
 
But I need for it to say 'Customer Records'!B7. Both those formulas you
gave me gave me the correct answer but I need to somehow get the cell to
display the formula 'Customer Records'!B7. Does this make sense? Its kind
of confusing.


thanx
 
Back
Top