+ Reply to Thread
Results 1 to 3 of 3

formula to reference a sheet not created yet

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    oakhurst
    MS-Off Ver
    2010
    Posts
    11

    formula to reference a sheet not created yet

    hello all again, so Iam trying to enter a formula =IFERROR('[masterfile.xlsm]5-19'!$H$16,"") into a cumulative summary and i want to enter the formula for each date so the formula for the next date is =IFERROR('[masterfile.xlsm]5-20'!$H$16,"") however if i try to enter formula for all the dates i cant enter it into the formula bar because it come up with an error that says invalid reference how can i avoid this so that i can update all the formulas without creating the sheets for every day?


    i will upload my docs so u can see what im trying to do. In cell G9 i enter =IFERROR('[masterfile.xlsm]5-20'!$H$16,"")
    because it is the date 5-20 and i want it to reference the sheet named 5-20 in the other book which has not yet been created because it is not 5-20 obviously thanks for any help in advance i really appreciate it

    BTW it all works if the date sheet is created i just dont want to go through and create all sheets
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: formula to reference a sheet not created yet

    would indirect work for you?

    =IFERROR(INDIRECT('[masterfile.xlsm]5-20'!$H$16,)"")

  3. #3
    Registered User
    Join Date
    12-05-2012
    Location
    oakhurst
    MS-Off Ver
    2010
    Posts
    11

    Re: formula to reference a sheet not created yet

    i dont believe that will solve my issue but thank you for giving it a shot i actually cant get that formula to work at all

+ 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