B
bmccall17
Ok I have a situation where I would like to call a specific workshee
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 int
a summary of invoices. The worksheets are named after the invoic
number. The invoice number is also listed in the summary. So, I woul
like to simply plug in the invoice number (same as worksheet name) an
the rest of the information from that worksheet will automatically b
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.
Bret
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 int
a summary of invoices. The worksheets are named after the invoic
number. The invoice number is also listed in the summary. So, I woul
like to simply plug in the invoice number (same as worksheet name) an
the rest of the information from that worksheet will automatically b
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.
Bret