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

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Αρχιτεκτονική Λογισμικού Visual Basic

Ταυτότητα Εργασίας: #18865806

Σχετικά με την εργασία

2 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

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 σε 1 μέρα
(114 Αξιολογήσεις)
6.2

2 freelancers κάνουν προσφορές κατά μέσο όρο $40 για αυτή τη δουλειά

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 Περισσότερα

$50 USD σε 1 μέρα
(210 Αξιολογήσεις)
6.8