Find Jobs
Hire Freelancers

Build Excel VBA Script to PDF Reports from a Pivot Table

$15-25 USD / hour

Completed
Posted about 4 years ago

$15-25 USD / hour

I currently have an Excel file that I create quarterly that includes a pivot table. Each quarter I manually have to select a company name and then run an All location report, then a report for each individual location. Each report then needs to be PDF'd. It takes several hours for me to manually pull all the reports. I'm looking for a VBA script that can be run to pull the reports and PDF them for me. Each quarter the list of company names and locations changes so the script needs to be generic enough to adapt each quarter. When creating the PDF, the file needs to be fit to page.
Project ID: 24068973

About the project

39 proposals
Remote project
Active 4 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
I know your TIME is VALUABLE so, honestly, thanks for reading my proposal. I have read your project and I can do it. I will build for you a file that will automatically generate the PDF's in separate Folders depending on client needs. My TOP clients: AVAYA, The Home Depot and Nike. I am a professional. Why choose ME? - Your satisfaction is always my first goal. - I deliver quality on time - I take only the clients I can attend myself PERSONALLY Pleased take some minutes to visit my portfolio and see both my work and my happy client's comments. We can start a chat to discuss the details of your project.
$20 USD in 40 days
5.0 (62 reviews)
6.5
6.5
39 freelancers are bidding on average $22 USD/hour for this job
User Avatar
Dear Employer, I understand you need a tool to create auto PDFs from the Excel file. Please message me, I will do the job for you. Please check my previous reviews. We can talk about the prices. Thanks and Regards, Ash
$25 USD in 40 days
5.0 (296 reviews)
8.4
8.4
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will print the selected pivot table's views in separate pdf files. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $25/hour and I will spend no more than 4 hours in total. I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$25 USD in 4 days
5.0 (533 reviews)
8.5
8.5
User Avatar
Hi, I am good at Excel VBA programming in pivot tables. I can access the fields in the pivot table and create the pdf report. Looking forward to work on the project. I can make the program dynamic. -chandra
$25 USD in 4 days
5.0 (1199 reviews)
8.4
8.4
User Avatar
Hello, I can help you with your project - Build Excel VBA Script to PDF Reports from a Pivot Table I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$20 USD in 40 days
4.9 (566 reviews)
8.5
8.5
User Avatar
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$25 USD in 4 days
5.0 (500 reviews)
8.0
8.0
User Avatar
Hi, I will make Visual Basic code to convert report to PDF automatically from excel as per your requirement with good and professional quality without any error. Need to see full file before start. I have completed more then 100 project within 8 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed
$15 USD in 40 days
5.0 (435 reviews)
7.7
7.7
User Avatar
Hello, this is Mauricio. I'm the Excel and VBA expert of our team. I've more than seven years of experience developing on the tool and have created automated PDF reporting tools using VBA. It would be great to discuss the details via chat and start working on the project right away.
$20 USD in 5 days
4.9 (183 reviews)
7.8
7.8
User Avatar
Hello I am financial expert and guru in Excel with extensive knowledge and expertise in advanced formulas, pivot tables, tables, and visual basics, including preparation of graphical and visualisation reports dynamic dashboards, and charts. I deal with exporting and importing databases and create automation with VBA. My modules allow to fill and validate information on forms (with drop-down list ) and to add them in structured tables and build-in reports. Furthermore, I have experience in accounting, financial statements, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, long term debts, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$20 USD in 40 days
4.9 (95 reviews)
7.5
7.5
User Avatar
Dear sir/madam, I have done several projects on data mining, visualization, data scrapping, and then produced cohor analysis, dashboards, market segmentation, linear discriminant analysis etc. Over the years , my work load has increased and I have a partner who worked in the quantitative finance industry in the US and also a faculty at University of Dallas, TX. Competency wise there is not much that we cannot do for such project, the rest can be discussed further when we talk. We have expert level proficiency in Excel, Tableau, Python, R , SQL, and SAS. Thanks
$20 USD in 40 days
4.9 (219 reviews)
7.1
7.1
User Avatar
I can do it for you quickly and exactly .Please contact me for saving your time and your moneys .
$20 USD in 40 days
4.9 (136 reviews)
7.2
7.2
User Avatar
$15 Only ------ In just 4 Hours ------ I can your VBA Macro Program to make PDF report based on your Pivot table absolutely as you want ------ Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ------ I can start right now, please message me to discuss more.
$15 USD in 40 days
5.0 (395 reviews)
6.8
6.8
User Avatar
Hi, Would you like to see a quick demo of your Excel VBA script built to pull data from a pivot table and convert them to PDF format before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$25 USD in 40 days
4.9 (74 reviews)
7.0
7.0
User Avatar
Hi, As per requirements, I will develop VBA macro to automate the process as per the description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I look forward to discussing the project with you and hopefully secure a long term working relationship. Thanks and regards, Mohan
$25 USD in 40 days
5.0 (100 reviews)
6.5
6.5
User Avatar
Hey, I reviewed the screenshots you created and can certainly create macros to do the whole process on click of a button and generate the pdfs as required. Could you share the workbook and details of the steps you follow? Look forward to hear from you. Best Regards, Rishi (Automyze Consulting)
$20 USD in 10 days
4.9 (176 reviews)
6.8
6.8
User Avatar
Hello, I'll be glad to assist to build the Excel tool to export your reports as pdf files according to your requirements. I have experience with Excel, formulas and Visual Basic that allow me to complete this project for you. Please contact me then we could discuss further details! Luis R
$25 USD in 40 days
5.0 (181 reviews)
6.1
6.1
User Avatar
Hello, Dear Recruiter I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f Best solution here will be Ms Access app. Dear Recruiter, I'll explain it via private chat for your customer. I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$20 USD in 40 days
4.8 (47 reviews)
6.2
6.2
User Avatar
I WOULD LIKE TO QUOTE AND PLACE MY BID FOR YOUR PROJECT NAMED Build Excel VBA Script to PDF Reports from a Pivot Table Do you need a reliable and professional virtual assistant for Data Entry, Web Research or List Building Projects using MS Excel? Yes, you are at the right place. Please check out my expertise below and the gig extras I'm offering. Expertise:  Offline/Online Data Entry Jobs  Web Research Jobs  Linkedln Data Collection  Companies Emails Research  B2B Lead Generation  Contacts and Email Research for Marketing and Business Purposes  Email Marketing Lists  Instagram Data Collection  Social Medias Research  Microsoft Excel Data Cleaning  PDF to Excel/CSV Conversion  Copy Paste Tasks  Data Capturing from Websites  Data Collection  Data Mining  Mailing Lists Creation  Business Cards into Ms Excel  Typing Work Why trust on me?  Top Rated Seller  Quick Turnaround  Quality Customer Support Regards, Anusha
$15 USD in 35 days
4.8 (52 reviews)
5.7
5.7
User Avatar
Hi, I'm interested in your project, I can write you VBA code to automate (export pdf reports) these tasks. I have rich experience in VBA-Macro(Excel, Powerpoint, Word, Web scrapping, API, ....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
$20 USD in 5 days
4.6 (61 reviews)
6.1
6.1
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$20 USD in 40 days
4.8 (38 reviews)
5.3
5.3
User Avatar
I can do the job! I can automate the tasks you all ready do (a propose a configurable task list), then add a function to save every configured sheet as pdf. Depending on the length of task to automate, I think a could do it in under 4 hours. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$25 USD in 40 days
5.0 (47 reviews)
5.4
5.4

About the client

Flag of UNITED STATES
Alexandria, United States
5.0
10
Payment method verified
Member since Dec 14, 2015

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.