Formula Question

  • Thread starter Thread starter troxelone
  • Start date Start date
T

troxelone

Probably an easy question, but I can't figure it out.

Is it possible to refer to different worksheets in a formula by a
cell. Here is an example to help clarify:

I want to refer to something on sheet2, which is usually ='sheet2'B2.
Is there a way to refer to this if I am working on sheet1 and list
a1=sheet2 then type ='a1"B2?

I have a ton of formulas that I don't want to change each time. It
would be so much easier if I can reference the sheets with a cell.

Thanks!
Theron
 
Back
Top