paquirl
Board Regular
- Joined
- Oct 12, 2010
- Messages
- 226
- Office Version
- 2016
- Platform
- Windows
i need a macro that will do what i am doing manually:
1. i set an autofilter.
2. i then filter results by the "Weeks Late" column for anything greater than or equal to 5 to 6 weeks. i mark the results by highlighting and change column filter back to show all results for that column.
3. then i filter by the "Mat'l Status" column for anything status 45 or 55. i mark the results and change column filter back to show all.
4. then i filter by "Sufficient Inventory?" column for anything with "yes." i mark the results and change filter back to show all.
5. finally i show all the marked results which is what i want in the end.
can anyone please help?
1. i set an autofilter.
2. i then filter results by the "Weeks Late" column for anything greater than or equal to 5 to 6 weeks. i mark the results by highlighting and change column filter back to show all results for that column.
3. then i filter by the "Mat'l Status" column for anything status 45 or 55. i mark the results and change column filter back to show all.
4. then i filter by "Sufficient Inventory?" column for anything with "yes." i mark the results and change filter back to show all.
5. finally i show all the marked results which is what i want in the end.
can anyone please help?
