Need a macro to filter necessary info into new tabs within a worksheet part 2
$10-30 USD
Πληρώθηκε κατά την παράδοση
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
Ταυτότητα Εργασίας: #18865806
Σχετικά με την εργασία
Ανατέθηκε στον:
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
2 freelancers κάνουν προσφορές κατά μέσο όρο $40 για αυτή τη δουλειά
"""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 Περισσότερα