+ Reply to Thread
Results 1 to 2 of 2

dynamic worksheet reference

  1. #1
    Registered User
    Join Date
    09-19-2005
    Posts
    4

    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

  2. #2
    Bob Phillips
    Guest

    Re: dynamic worksheet reference

    Try using INDIRECT, such as

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

    --
    HTH

    Bob Phillips

    "bmccall17" <bmccall17.1vm8ik_1127149558.311@excelforum-nospam.com> wrote in
    message news:bmccall17.1vm8ik_1127149558.311@excelforum-nospam.com...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1