Find Jobs
Hire Freelancers

Excel VBA Work - Filter Pivot, Copy, Paste, save as new File

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
I need help to write a macro which will: - Filter 3 seperate pivots with different data sources based on the same filter criteria (i.e. all have same supplier number) - Copy the pivots and other defined cell data - Open the blank workbook template - Paste in the data from the 3 pivots as well as other additional cell data - save the template with a new name using the supplier name - Repeat and use the next supplier. Ultimately the macro will create a new workbook for each supplier based on a template and fill it with data from a master data source. Note that this is for dummy data, and i will take the macro and use it for the real data so please add comments in the macro which can help me understand what's going on. e.g. "This is saving the file in this file location"
Project ID: 6725099

About the project

6 proposals
Remote project
Active 9 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
please inform about next step .
$30 USD in 2 days
5.0 (6 reviews)
3.6
3.6
6 freelancers are bidding on average $30 USD for this job
User Avatar
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.
$30 USD in 1 day
4.9 (8 reviews)
3.7
3.7
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$29 USD in 3 days
5.0 (3 reviews)
3.2
3.2
User Avatar
I am expert in excel and excel macros and worked on several complex features. I would like to work with you. Please let me know further. Regards, Selvan
$30 USD in 1 day
5.0 (4 reviews)
3.1
3.1
User Avatar
Hello, i am expert in VBA jobs can help you payment after job completion by milestone waiting your answer on chat Regards
$30 USD in 1 day
4.4 (1 review)
1.4
1.4
User Avatar
Hi I'm an IT student with good knowledge in excel and can help you to do your job. Please check my review and my portfolio and let me know if you interested to work with me. I will promise to do my best and I have very good experience in this field.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$28 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Nundah, Australia
5.0
11
Payment method verified
Member since Jul 3, 2013

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.