Contents of a cell refer to sheet name

  • Thread starter Thread starter Audio_freak
  • Start date Start date
A

Audio_freak

Hello there

I would like to do something like this:

in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:

='A1!'C5

so that it will look in sheet2 because that's the value in A1.

Doesn't work, does it?

Thanks

Peter
 
=Indirect("'" & A1 & "'!C5")


the single quote is to the left of the exclamation point.
 
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

VBA Countif across sheets? 5
Refer to sheets without using tab name?? 4
Naming non-contigent cells with vba 5
Run two macros for two different sheets 11
Refering to a particular cell in a Named Range 3
Extracting a Part of a Formula as Text 5
Copy range from one sheet to another cell by cell 2
combo box 1

Back
Top