In the simplest terms possible, i am new to excel so i dont know if this is possible
I have a spreadsheet with multiple sheets. In each of these sheets there is a data set with columns and rows. They rows are all activities that need to be completed and each activity belongs to mostly one sometimes two different departments. "Department" is one of the columns in this data set. Each sheet is laid out in the same way with activities and responsible departments (there is more to the data but this is it in its simplest form). Is there a way whereby, on a separate sheet (the first sheet), i can create a link to click for each department to click on and it will filter out all subsequent sheets for activities relating to their department? If not a clickable link but a drop down menu where a department can select their department name and that would result in all subsequent sheets being filtered out by the department selected? I want each department to be able to access the same sheet and filter out their own "work" to do easily
Hopefully that makes sense and hopefully you can assist
I have a spreadsheet with multiple sheets. In each of these sheets there is a data set with columns and rows. They rows are all activities that need to be completed and each activity belongs to mostly one sometimes two different departments. "Department" is one of the columns in this data set. Each sheet is laid out in the same way with activities and responsible departments (there is more to the data but this is it in its simplest form). Is there a way whereby, on a separate sheet (the first sheet), i can create a link to click for each department to click on and it will filter out all subsequent sheets for activities relating to their department? If not a clickable link but a drop down menu where a department can select their department name and that would result in all subsequent sheets being filtered out by the department selected? I want each department to be able to access the same sheet and filter out their own "work" to do easily
Hopefully that makes sense and hopefully you can assist