How do I put a variable in a formula in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If you mean by a simple formula
=sheet1!a1
where cell k2 has sheet1 written in it
=INDIRECT(K2 &"!a1")
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
filtering data for analysis 6
Deleting blank rows with formulas in them 7
Summing up various Worksheets to one Summary sheet using variables 1
one cell in my worksheet appears blank, but answr shows in formula 6
Summarise data from several worksheets in a workbook 2
Summing VLookup from a variable number of sheets 4
variable sheet name 6

Back
Top