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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

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