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