+ Reply to Thread
Results 1 to 3 of 3

reference to the cell which in turns refers to the worksheet based on the value of the cel

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    New Delhi
    MS-Off Ver
    Excel 2007
    Posts
    12

    reference to the cell which in turns refers to the worksheet based on the value of the cel

    Dear experts.

    My requirement is as below.

    In a excel file i want to enter the formula which refer to the cell. The data written in the cell refer to some other worksheet.

    The formula should give the final result of the cell in the other worksheet.

    For Example

    below Data is written in cell A1 and A2 and A3 of worksheet "june" and in another worksheet named "May" 9876 is entered in cell number D45.

    Cell A1 Data is "May"
    Cell A2 Data is "D" This D should correspondence to the Column D of the Worksheet named "May"
    Cell A3 Data is "45" This 45 means the formula should correspondence to the Row 45 of the worksheet named "May"

    Requirement for the formula

    We need to use the formula in cell A4 and the result of the formula should be 9876.

    thanks in advance.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: reference to the cell which in turns refers to the worksheet based on the value of the

    =indirect(a1&"!"&a2&a3)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    New Delhi
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: reference to the cell which in turns refers to the worksheet based on the value of the

    Dear Support team

    i think i am not able to explain the requirement.

    i am trying to explain the requirement as below once again.

    there is one formula below.
    ='YTD Feb-14'!B4
    ='YTD Feb-14'!B5
    ='YTD Feb-14'!B6
    ='YTD Feb-14'!B7
    ... and so on.

    next month say mar-14 i had to change the month physically so that the values will be updated automatically.

    The requirement is that i need some indirect function which can be used within the formula so that i need to change the month only once in the entire worksheet and all the Feb-14 month changes to Mar-14 automatically.

    like

    ='YTD(indirect(a1)'!B4

    this A1 is cell location within the same worksheet where i will write the month as "Mar-14" and all the formula will be automatically starts refering to Mar-14 worksheet.

    please help.

+ 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. Copy data from a copied worksheet to another worksheet based on cell reference
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2013, 02:18 PM
  2. Forumla which refers to a cell which refers to a sheet name
    By awiller2 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-03-2012, 09:57 PM
  3. Replies: 4
    Last Post: 10-30-2012, 06:15 PM
  4. Display data reference from another worksheet based on cell reference
    By Drew123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2011, 03:52 PM
  5. Replies: 12
    Last Post: 07-08-2011, 10:48 AM

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