+ Reply to Thread
Results 1 to 3 of 3

Help with reference Function

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    Space
    Posts
    14

    Help with reference Function

    I'm trying to reference a cell on a different page that I named: Job1A

    I have tons of pages with identical forms that reference Job1a, Job1b, Job1c, Job2a, Job2b, Job2c as well as the same thing for grass1a, grass1b, grass1c, grass2a, grass2b, grass2c ETC ETC ETC.

    I want to be able to put the word "Grass" or "Job" into Cell A1 of every sheet depending on what it's in reference to, and then call out the cell named Job1a.

    Right now it's set up for: =+Job1a

    I'd like to be able to write: =+(A1)1a and have it recognize A1 as the word JOB and then reference =+JOB1a.

    Any way i can do this?

    Thanks!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You mean?

    =Indirect(A1&"1a")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-27-2008
    Location
    Space
    Posts
    14
    I'll try it. One sec.

    BINGO. You're a GENIUS!

    That's gonna save me like 100 years of time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 error when adding custom help file to user defined function
    By sabotuer99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2009, 01:10 AM
  2. Reference Function Help - Sports Ranking Data
    By sportsranker in forum Excel General
    Replies: 2
    Last Post: 03-11-2008, 02:06 PM
  3. Converting a VBA output String to a Cell Reference
    By redefine in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2007, 02:22 AM
  4. Using a relative cell reference in a function
    By john williams in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2007, 06:49 AM
  5. reference worksheets setup ?
    By akm in forum Excel General
    Replies: 1
    Last Post: 09-18-2006, 11:05 PM

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