Referencing tabs through cells in excel

Discussion in 'IT & Internet' started by ImproveSearchListings, Oct 20, 2009.

Thread Status:
Not open for further replies.
  1. ImproveSearchListings

    ImproveSearchListings Contributor

    707 35
    Hope someone can help.

    I have three tabs - lets call the tab 1, tab 2 & tab 3.

    In the first tab i have in cells:

    A2 - BD
    A3 - CE
    A4 - DF

    B1 - tab 2
    C1 - tab 3

    I need cell B2 to reference a cell in tab 2.

    I need cell C2 to reference a cell in tab 3.

    This works: ='tab 2'!$H7

    Instead of 'tab 2' I want to reference cell B1 as I have a significantly higher number than my example here.

    Is this possible as ='B1'!$H7 doesn't work.

    Thanks - I hope I've made this clear.
     
    Posted: Oct 20, 2009 By: ImproveSearchListings Member since: Dec 5, 2006
    #1
  2. cde3879

    cde3879 UKBF Newcomer

    14 1
    Sorry but that doesn't make sense unless I am being dense.

    ='B1'!$H7 will only work if you have a tab called B1, and it will insert the contents of H7 on that tab into the cell containing the formula. If you don't have a tab called B1, the command will error.

    What error are you getting? Excel errors are normally quite helpful if you look at the formula error help.
     
    Posted: Oct 20, 2009 By: cde3879 Member since: Oct 17, 2009
    #2
  3. Subbynet

    Subbynet Contributor

    6,004 1,101
    Type =, go find cell to reference (in any tab), and click enter.

    Job done, unless I too am missing something?
     
    Posted: Oct 21, 2009 By: Subbynet Member since: Aug 1, 2005
    #3
  4. JElder

    JElder Contributor

    1,144 192
    Yes - use the selector as the easiest way. You can also select a particular tab/cell in a formula by using the formula builder, then using the little button next to each part of the formula. It will then revert to a view of the worksheet, so select the tab and cell (or range) you need.
     
    Posted: Oct 21, 2009 By: JElder Member since: Jul 2, 2008
    #4
  5. ImproveSearchListings

    ImproveSearchListings Contributor

    707 35
    Thanks everyone, but excel has created a monster.

    After making everything easier for me across the years, I now expect it to do even more....faster......better - making me lazier.
     
    Posted: Oct 22, 2009 By: ImproveSearchListings Member since: Dec 5, 2006
    #5
Thread Status:
Not open for further replies.