Forum Discussion
Change references from one sheet to another
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.
mathetes thanks for answering.
I'll attach the file.
I'm quite confident with pivot tables, but not enough to produce them in order to give me the result I need, for example to compare one sheet to the other.
I might gonna give it a try..
I'm sorry, but I can't figure out how to navigate those. Part of that is language, of course, and I have to apologize for my limitations in that regard. But beyond that, we'd need to sit together face-to-face, unless you can really provide a good description of what all those sections of the various sheets are about.