Forum Discussion
Weekly Report Isolation from raw data
Hi All, I've got an old excel file at my work that tracks sales and then sorts it into other sheets to track individual salesmen, ytd salesmen, stores and ytd stroes. I've trying to update it an...
Please attach your sample file but modify confidential names to generic ones to preserve the confidentiality of your data.
I guess I didn't metion that this excel file cross-references a second excel file, meaning both must be open to make changes, which currently run through our server.
I am trying to make everything in one standalone excel file.
Making a change to names, messes up the cross-referencing values of the sheet in question.
- In that case, you have to analyze the formulas that depend on ReportWeek.
