Lengkap

Need a macro to filter necessary info into new tabs within a worksheet

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

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic

Lihat lagi: macro coding copying info web excel, excel macro searching websites info, excel macro filter copy, vba code to filter data in excel, excel vba filter multiple criteria, excel vba autofilter multiple fields, autofilter vba, excel vba autofilter copy visible rows, excel copy filtered data to another sheet automatically, macro to filter data and copy to another workbook, excel vba filter column based on cell value, macro filter vlookup sheet, xls macro filter, excel macro filter pivot, outlook 2007 macro filter, excel macro formatting cut paste across tabs, need macro excel repeats copy paste, macro search websites info excel, macro search website info excel, vba macro filter unique results

Tentang Majikan:
( 0 ulasan ) Chicago, United States

ID Projek: #18860615

Dianugerahkan kepada:

rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$30 USD dalam 30 hari
(114 Ulasan)
6.2

2 pekerja bebas membida secara purata $28 untuk pekerjaan ini

Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Lagi

$25 USD dalam 0 hari
(29 Ulasan)
4.1