Reference another worksheet using a cell

L

Lynxbci3

I have a main worksheet that pulls data from one of several other
worksheets. I would like to be able to type into cell the name of the
worksheet that i wish to use. Is this possible?

E.g
In cell A1 you type worksheet1.xls
In Cell A3 the Formula ='[WORKSHEET1.xls]Sheet1'!$A$5
If i then change A1 to workseet2.xls i want the formula in A3 to change
to
='[WORKSHEET2.xls]Sheet1'!$A$5

Something like = A3!Sheet1!$A$5 but this doesn't work

thanks in advance
 
D

Dav

Something like the following should work for the formala in cell A3
although the workbook being referenced needs to be open.

=INDIRECT("'["&a1&"]sheet1'!$a$5"
 

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

Reference to another worksheet cell in a sumproduct formula 1
How do I make worksheet2 = to worksheet1? 2
Formula to reference another worksheet 4
Formula within filename link 2
got to cell on seperate worksheet 2
Nested if issue 1
Blank Cell Reference, without if statement 4
SumIf with multiple Criteria 6

Top