+ Reply to Thread
Results 1 to 2 of 2

Reference to worksheet name using cell value

  1. #1
    Registered User
    Join Date
    02-28-2008
    Posts
    14

    Reference to worksheet name using cell value

    Hello to everyone, this is my first post on here. I have looked but couldn't find an answer to this.

    I have worked as a programmer before so tended to do anything complicated using a program written for the purpose so have only used Excel occasionally. I have started to use it more often now and was trying to create a household budget planner.

    I have created a seperate tab for each expense named for example 'mortgage', 'house insurance' etc.

    On the first 'master' page I can refer to data on the other pages without problem but, rather than typing the name on a worksheet numerous times, is there a way of using the value of one cell as the name of the reference worksheet. ie

    | 8 | 9 | 10
    A | mortgage | =mortgage!$B$4 | =mortgage!$B$6


    The column 8 has the name of the worksheet in it and I wanted to replace the word 'mortgage' in the reference of A9 and A10. This will make errors less likely and updating/adding etc easier.

    Something like a9 being =(A8)!$B$4 <<<<-- This obviously doesn't work

    Thanks in anticipation...

  2. #2
    Registered User
    Join Date
    02-28-2008
    Posts
    14
    Found a way !!

    Nested INDIRECT commands

    =INDIRECT("'"&INDIRECT("B27")&"'!$b$7")

    Where the cell B27 contains the name of the worksheet I need to reference and B7 contains the data.

    Unless there is a less painful way of doing it!

    I am using VLOOKUP commands in 5 cells across the spreadsheet and this causes as many problems as naming them each time anyway!
    Last edited by cowasaki; 02-28-2008 at 09:44 AM.

+ 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