Need help to create a rule to change data based on the heading

brandonhh

New Member
Joined
Dec 11, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hey team,
In the one spreadsheet I have a data tab that has different pieces of information from 5 departs organised in a weekly table format, as a master sheet. I then have another sheet that summarizes data for each department individually with a week on week trend, but only for that month in total. At this stage im having to copy data from outside reports twice, once into the master sheet, and once into the monthly department sheet. Ive been able to create a list at the top of the monthly department sheet to select different dates, but need help creating the rule, that will adjust the data on the monthly sheet depending on what date is selected at the top.
The attached file with the blue heading is the monthly department sheet named 'Audio department' and the purple heading is the master sheet named 'Q2'.
Any help would be appreaciated!
 

Attachments

  • 1670809902094.png
    1670809902094.png
    30 KB · Views: 20

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top