I want a macro that filters the attached report into a new tab based on the "PV WORK WEEK" Each week a new report is generated and the weekly information I need advances by 1 week. "T7" which is "PV WORK WEEK" 2019-16 this week will be 2019-17 next week and then 2019-18 the following week.
The current week is "T0" which is 2019-09 you can verify based on the "ES" date which stands for start date. 1 PV week range is Monday-Sunday
I need a new tab for each of the following T weeks.
"T4" which is 4 weeks out from the current PV WEEK 2019-13 next week 2019-14 will be T4
"T7" is 7 weeks out from the current PV WEEK 2019-16 next week 2019-17 will be T7
"T10" is 10 weeks out from the current PV WEEK 2019-19 next week 2019-20 will be T10
"T15" is 15 weeks out from the current PV Week 2019-24 next week 2019-25 will be T15
Filter by Discipline show only "TC"
Filter by Division show only
"DCZ300, DCZ302,DCZ305,DCZ306,DCZ307,DCZ310,DCZ312,DCZ314,DCZ315,DCZ335, STA13, STA7, TSS33, TSS41, TSS43,TSS55,TSS63, TSS89,TSS104,TSS118,TSS137,TSS150,TSS174,TSS192,TDC814, Everything that starts with SS8**, Everything that starts with ESSZ**, Show all the items that are blank or empty under division column.
I want only the columns below to be shown in each new tab.
PV WORK WEEK/ Es/ System Code/ Schdblog/ Work Order Nbr/ Work Order Task/ Division/ Equipment Number/ Wr Task Title/ Work Order Type/ Pm Due Date/ 75% of Grace Date/ Compliance Overdue Date/ Discipline /Schedule Group/ Staff Required/ Expense Manhours/ Com