Excel VBA to run through a dropdown list, printing pdfs of each option.

$10-30 AUD

Completed

Posted

over 5 years ago

$10-30 AUD

Paid on delivery

I am after a bit of VBA for excel written up that will: On click of a button: - Refresh the following data sheets: ------Project Actuals ------Project Budgets ------Project Forecasts ------PPO List ------Benefits List ------ICT PMO List (These worksheets will remain hidden in the final version. They pull from an internal SharePoint server, so it will likely throw an error for you.) - It will the ask where the user wants to save the produced reports - It will then save/print to pdf the print area for worksheet 'Report (1.1)' for each option in the dropdown list found in cell N2 of the 'Report(1.1)' worksheet. - Each pdf will be saved with the text that is found in cell N3 of the 'Report(1.1)' worksheet as the title. The VBA should have a status indicator to show the user the progress over how many have been completed.

Visual Basic for Apps

Project ID: 18028400

About the project

8 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a macro to ask you for the location where you want to save converted pdf file then save the printable area of worksheet into pdf file. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra

$30 AUD in 1 day

4.8

(69 reviews)

5.3

8 freelancers are bidding on average $131 AUD for this job

@deepbluetech

Hi, I am an Excel VBA expert with more than 15 years of experience in this field. I propose to deliver a functional Excel VBA code meeting your requirements. Let me know. Regards, Arul

$200 AUD in 3 days

5.0

(218 reviews)

7.3

@Tanmoy236

"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 more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "

$80 AUD in 1 day

4.9

(165 reviews)

6.6

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$150 AUD in 3 days

4.8

(56 reviews)

5.4

@tiaratechies

Hello, we are a team of excel experts that are experienced in handling Visual Basic programmes if you are interested in hiring us drop a message.

$500 AUD in 2 days

5.0

(37 reviews)

5.2

@akhileshgandhi

Hello There, I am Microsoft certified SharePoint developer and have 15+ years of experience working with Microsoft and Sandisk in US. I can develop, customize, migrate & integrate your SharePoint portal. I have deep experience with Sharepoint branding, SharePoint Development, Sharepoint Online and Build Sharepoint Apps. Also, I have experience with architecting solutions for large enterprises. Akhilesh,

$25 AUD in 1 day

4.5

(14 reviews)

5.4

@prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

$30 AUD in 1 day

4.4

(34 reviews)

4.1

@paulodayto08

Hi Good Day! A serious freelancer here! I can help you to complete this work in less than a day. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

$30 AUD in 1 day