Lengkap

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

I need a macro to filter the attached report based on "PV WORK WEEK" and "Discipline" - TC and create a new tab for each "Schedule group".

Filter for "PV WORK WEEK = 2019-25" - I want to be able to edit the PV WORK WEEK. Next week this will need to be filtered for "PV WORK WEEK=2019-26"

A new tab for all "Discipline = TC" under "Schedule Group=include every group listed"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TC"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCCOM"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCDIS"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCFIN"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCPWT"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCSCA"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=TCTRA"

add total "Expense Manhours" somewhere on the spreadsheet

A new tab for all "Discipline = TC" under "Schedule Group=Everything other than TC,TCCOM,TCDIS,TCFIN,TCPWT,TCSCA,TCTRA, including blanks"

add total "Expense Manhours" somewhere on the spreadsheet

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: excel vba advanced filter copy to another sheet, excel vba filter multiple criteria, macro to filter data and copy to another workbook, excel vba advanced filter multiple criteria, how to filter data in excel using macro, advanced filter excel, excel vba advanced filter criteria examples, vba code to filter data in excel, macro coding copying info web excel, excel macro searching websites info, excel macro filter copy, 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: #18865806

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 sehari
(114 Ulasan)
6.2

2 pekerja bebas membida secara purata $40 untuk pekerjaan ini

Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Lagi

$50 USD dalam sehari
(210 Ulasan)
6.8