Hello everyone,
whenever I have a workbook that pulls info from multiple worksheets, if I have to replace one of the worksheets with an updated version and name the sheet with the same name as the older sheet, and then delete or change the name of the older sheet, all the formulas that were referencing the older sheet instead reference #REF.
Is there anyway to keep all the formula references the same, and simply swap out the sheets and delete the old sheet without this error?
Thanks in advance.
Bookmarks