+ Reply to Thread
Results 1 to 3 of 3

Drop down to Reference Sheet Name

  1. #1
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Drop down to Reference Sheet Name

    Hi everyone,

    This should be a pretty quick question. I have a drop down with a list of companies. Each company has their own dataset and information tab, named the same as the drop down.

    When they drop down, I just want to insert the formula into the formula bar. I tried to use indirect, but it does not like me. What am I doing wrong?

    Thanks.

    I've searched a pretty good amount, and can only find how to change the operator, which seems similar, but it ends up being different enough where the process doesn't translate.
    Attached Files Attached Files
    Last edited by jake.masters; 11-15-2012 at 03:34 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    San Francisco
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,163

    Re: Drop down to Reference Sheet Name

    The formula in B8 should be
    =SUM(INDIRECT(B4&"!A:A")) you can apply the same concept to the rest.

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Drop down to Reference Sheet Name

    Ah I was just using:

    =SUM(INDIRECT(B4)!A:A)

    Thanks for the help.

+ 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