Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic cell reference? | Excel Discussion (Misc queries) | |||
Reference cells from another worksheet problem | Excel Discussion (Misc queries) | |||
How do I reference a worksheet name in a cell, or vice versa? | Excel Discussion (Misc queries) | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |