Forum Discussion
Solved
Change references from one sheet to another
Hello there, I have an issue and couldn't find a related argument already solved, kindly ask if somebody can help. On a Worksheet I have to update datas everyday, creating every day a new sheet tha...
nobiaiIt's probably best to use "Find and Replace" (Ctrl-H) to update the links to the previous sheet. For example, when you create a new sheet for "04.10" from sheet "03.10", select all cells in the new sheet, Find "02.10!' and replace with '03.10!'. Takes about three seconds to accomplish.
nobiaiIt's probably best to use "Find and Replace" (Ctrl-H) to update the links to the previous sheet. For example, when you create a new sheet for "04.10" from sheet "03.10", select all cells in the new sheet, Find "02.10!' and replace with '03.10!'. Takes about three seconds to accomplish.
Riny_van_Eekelen HERO!