Find Jobs
Hire Freelancers

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

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
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
Project ID: 18860615

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 30 days
4.9 (114 reviews)
6.2
6.2
2 freelancers are bidding on average $28 USD for this job
User Avatar
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 Thanks
$25 USD in 0 day
5.0 (29 reviews)
4.1
4.1

About the client

Flag of UNITED STATES
Chicago, United States
0.0
0
Payment method verified
Member since Mar 4, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.