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.
You know, I can't help but wonder if there isn't another way altogether to go about this reporting.
Are you, for example, familiar with Excel Pivot Tables? A Pivot Table can report on data over time, showing results day-by -day, or week-by-week, or month-by-month in the same category.
You'd keep the data for each day all in the same database, just making sure there's a column for each row that contains the relevant date.
Not knowing exactly what happens with the data you're working with, once you've done the comparisons on a row-by-row basis, it's difficult to be certain that a different approach would even work. But let me ask if you'd even be open to that? If you were, I think you'd find it less complicated, and possibly more informative to those that need the results of the analysis.
Finally, is it possible to post a copy of the spreadsheets? Only do so if they don't contain confidential info.
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.
