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 and can't quite seem to figure out how they are using the week filter.
On the older one, when you look at the sheet with the individual salesman breakdown, there is a dropbown box with the week number. Once you click it, you can isolate sales from those specific weeks.
I can't seem to figure out how to duplicate that.
What I've noticed about the old one is that when you click on the dropdown week cell it says, "ReportWeek" to the left of the formula bar. It also has the option of, "ReportWeek2", which when clicked takes you to the store weekly sales.
All of the raw data is coming from a sheet within the same excel file.