#ref error sheet not yet created

**ryanstout87** · 12-10-2012, 04:17 PM

hi, i have a workbook that i use to generate daily sheets with totals. i want those totals to go into a different workbook. my issue is when i creat formulas for the different days in the cummilative workbook i cant reference a sheet in the daily work book that has not been created yet. im capable of waiting everyday and then changing formula in cummilative but other users will not be able to.

here is an example =[masterfile.xlsm]12-10!$H$16 now for the next row i need it to be =[masterfile.xlsm]12-11!$H$16 and so on. i would like to update the cummalitave so that as the sheets in the other workbook are created it automatically updates any ideas?

**FDibbins** · 12-10-2012, 04:29 PM

to eliminate the #ref error showing, you could wrap the reference in iferror()

=iferror([masterfile.xlsm]12-10!$H$16,"")

it may still try and look for the file/sheet when you enter it, but will stay blank afterwards

**ryanstout87** · 12-10-2012, 04:39 PM

how do i get excel to accept the formula it pops up with dialoge box saying formula contains invalid references. im assuming it is because the next date is not created yet
=IFERROR('[masterfile.xlsm]12-17'!$H$16,"") does not accept it because 12-17 is not created yet???