Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello

    I am working on a sheet called 03.
    I need to reference/pull in information from the previous sheet called 02DelRec from cell cc523.

    My formula works when I use sheet numbers that do not have a zero in front of them.

    =INDIRECT("'"&TEXT(BX505,"00")&"'!cc523")
    where BX505 is the cell containing the sheet name - for example 02DelRec (does not work) or 11DelRec (works) etc

    Regards

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have you tried switching the code so it refers to the Worksheet numbers within the Workbook instead of the Worksheet names?
    Gre

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This may be too simplistic but have you tried:

    Put a + sign in the cell you want the data to appear
    Go to the other spreadsheet and highlight the cell that has the data you want
    Hit enter
    This will take you back to the first spreadsheet and the info will appear.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Shouldn't your formula be:

    =INDIRECT("'"&TEXT(BX505,"00")&"DelRec'!cc523")
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •