Home

Weekly Report Isolation from raw data

RPatton
New Contributor

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 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.

 

Any thoughts?

 

Thanks!

3 Replies
Please attach your sample file but modify confidential names to generic ones to preserve the confidentiality of your data.

@Twifoo 

 

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies