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
Bookmarks