How do I put a variable in a formula in Excel

A

Allan Skyner

I have several worksheets from the same template therefore data I want to
analyse is in the same cell on different worksheets. I want to use another
worksheet to analyse the data. Is it possible to set a formula with a
variable which will allow me to select cell data from the different
worksheets. In other words if I enter one sheet name I get the results from
that sheet and by enetering another sheet name the results from that sheet
appear in my analysis sheet.
 
D

Don Guillett

If you mean by a simple formula
=sheet1!a1
where cell k2 has sheet1 written in it
=INDIRECT(K2 &"!a1")
 
A

Allan Skyner

Thanks Don that was exactly the formula.

Don Guillett said:
If you mean by a simple formula
=sheet1!a1
where cell k2 has sheet1 written in it
=INDIRECT(K2 &"!a1")
Click to expand...
 
Top