Build Excel VBA Script to PDF Reports from a Pivot Table

Completed Posted 4 years ago Paid on delivery
Completed

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.

Excel Visual Basic Visual Basic for Apps Data Processing Data Entry

Project ID: #24068973

About the project

39 proposals Remote project Active 4 years ago

Awarded to:

urielbaray

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 More

$20 USD / hour
(62 Reviews)
6.5

39 freelancers are bidding on average $22/hour for this job

asin1987

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, A More

$25 USD / hour
(296 Reviews)
8.4
ParisPallas

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 f More

$25 USD / hour
(533 Reviews)
8.5
cgullapalli

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 / hour
(1199 Reviews)
8.4
schoudhary1553

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. More

$20 USD / hour
(566 Reviews)
8.5
P0L

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 / hour
(500 Reviews)
8.0
rashedkhanrubel

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 mo More

$15 USD / hour
(435 Reviews)
7.7
trascenderglobal

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 More

$20 USD / hour
(183 Reviews)
7.8
dgled

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 d More

$20 USD / hour
(95 Reviews)
7.5
fatimatuzzohura

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 More

$20 USD / hour
(219 Reviews)
7.1
zebracaro

I can do it for you quickly and exactly .Please contact me for saving your time and your moneys .

$20 USD / hour
(136 Reviews)
7.2
AnowarRatul

$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 w More

$15 USD / hour
(395 Reviews)
6.8
dvcontact

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 More

$25 USD / hour
(74 Reviews)
7.0
TechnoGuruu

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 a More

$25 USD / hour
(100 Reviews)
6.5
shikhamehta

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 fol More

$20 USD / hour
(176 Reviews)
6.8
beltran0404

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 f More

$25 USD / hour
(181 Reviews)
6.1
zu02

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 vis More

$20 USD / hour
(47 Reviews)
6.2
ARTICLEYOUWANT

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 Bui More

$15 USD / hour
(52 Reviews)
5.7
shahinrahimi

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 sav More

$20 USD / hour
(61 Reviews)
6.1
rIbrarahmed

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 myse More

$20 USD / hour
(38 Reviews)
5.3
ielucerotrad1

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 More

$25 USD / hour
(47 Reviews)
5.4