Wild Child
New Member
- Joined
- Jan 22, 2020
- Messages
- 11
- Office Version
- 2013
- Platform
- Windows
Is there a way to sort data based on information from another sheet in the workbook?
I have a sheet with the current jobs for the month, I have a master list that has all jobs on it, I need to filter the second list to have the same jobs as the first list.
The above list is the monthly data, the master list below is what I need filtered. Column "D" on both sheets have the same data.
Currently I have to manually filter the list and that takes several hours for me to complete.
I am somewhat new to excel and would appreciate any help!!
I have a sheet with the current jobs for the month, I have a master list that has all jobs on it, I need to filter the second list to have the same jobs as the first list.
The above list is the monthly data, the master list below is what I need filtered. Column "D" on both sheets have the same data.
Currently I have to manually filter the list and that takes several hours for me to complete.
I am somewhat new to excel and would appreciate any help!!