dynamic worksheet reference
 

Ok I have a situation where I would like to call a specific worksheet
using a reference to another cell as the worksheet name.

In the case that I am working on I have invoices that I am calling into
a summary of invoices. The worksheets are named after the invoice
number. The invoice number is also listed in the summary. So, I would
like to simply plug in the invoice number (same as worksheet name) and
the rest of the information from that worksheet will automatically be
completed.


Can someone please help me with the formula?
right now it looks like this:
[='InvoiceNumber'!$A$1]
it needs to look something like:
[='(call to invoiceNumber column for worksheet name)'!$A$1]


thanks.
Brett


--
bmccall17
------------------------------------------------------------------------
bmccall17's Profile: http://www.excelforum.com/member.php...o&userid=27371
View this thread: http://www.excelforum.com/showthread...hreadid=468869

Try using INDIRECT, such as

=INDIRECT("'"&A1&"'!"&B1)

--
HTH

Bob Phillips

"bmccall17" wrote in
message ...

Ok I have a situation where I would like to call a specific worksheet
using a reference to another cell as the worksheet name.

In the case that I am working on I have invoices that I am calling into
a summary of invoices. The worksheets are named after the invoice
number. The invoice number is also listed in the summary. So, I would
like to simply plug in the invoice number (same as worksheet name) and
the rest of the information from that worksheet will automatically be
completed.


Can someone please help me with the formula?
right now it looks like this:
[='InvoiceNumber'!$A$1]
it needs to look something like:
[='(call to invoiceNumber column for worksheet name)'!$A$1]


thanks.
Brett


--
bmccall17
------------------------------------------------------------------------
bmccall17's Profile:
http://www.excelforum.com/member.php...o&userid=27371
View this thread: http://www.excelforum.com/showthread...hreadid=468869