
Closed
Posted
I’m looking for assistance with coding an Excel document and wanted to check if this is something you can help with. Part 1: The workbook currently has around 60 tabs. I would like Tab 1 (Page 1) to act as a control page containing a series of checkboxes, each linked to one of the tabs. From Tab 1, the user would select the required tabs (for example: tabs 1, 9, 23, 45, 68). Once selected, clicking a button would generate a PDF containing only the chosen tabs. To make this easier, I do have another Excel document that already works in this way. While the structure of the two documents is different (so the code can’t simply be copied and pasted), the existing file could be used as a reference for the logic and approach. Part 2: Also on Tab 1 (Page 1), I’d like the user to be able to choose an output format (for example: Format A, Format B, Format C). Depending on the selected format, the PDF output would change its appearance. For example: Format A: Selected tabs exported with a blue heading Format B: Selected tabs exported with no headings Format C: Selected tabs exported with a green heading and green footer The format selection would apply to the same tab-selection logic described in Part 1.
Project ID: 40781450
169 proposals
Remote project
Active 16 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
169 freelancers are bidding on average $21 AUD/hour for this job

Hello, I have carefully reviewed your project description and it seems like you require Excel spreadsheet coding assistance for two main parts. The first part involves creating a control page in Tab 1 with checkboxes linked to other tabs for generating a PDF with the selected tabs. I understand the need for dynamic PDF generation based on user selection, similar to your existing Excel document. In the second part, the user should be able to choose different output formats on Tab 1, which will impact the appearance of the PDF output. This customization, such as different colored headings and footers based on the selected format, adds a layer of user-friendly functionality to the project. With my expertise in Excel VBA coding and creating interactive user interfaces, I can develop a solution that meets both requirements efficiently. By leveraging VBA macros and Excel functions, I will ensure seamless integration of the control page, tab selection, and PDF generation features. Feel free to explore my portfolio for similar projects: https://www.freelancer.com/u/Microlent If you have any questions or would like to discuss the project further, please initiate a chat. I am here to help you streamline your Excel document for enhanced usability. Sincerely, Rajesh
$15 AUD in 40 days
9.4
9.4

Hello, We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time. We are 25 years in this business and our technical specialists have strong experience in JavaScript, Visual Basic, Excel, Software Architecture, Excel VBA, Excel Macros, Data Visualization, Data Analysis and other technologies relevant to your project. Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews. Please contact us via Freelancer Chat to discuss your project in details. Best regards, Sales department Tangram Canada Inc.
$30 AUD in 5 days
8.2
8.2

A workbook with around 60 tabs and conditional PDF output is an excellent match for my 10 years of Excel VBA and macro experience. I have helped more than 450 freelance clients with Excel automation, reporting, scheduling, sheet compiling, and custom dashboards, giving me the practical experience needed to build reliable controls directly into your workbook. I can create the Tab 1 control page with linked checkboxes, a selection button, and VBA logic that exports only the chosen tabs to PDF. I can also implement the format selector so the same selected sheets are exported with the appropriate heading and footer styling for Format A, B, or C. Your existing working workbook can serve as a useful reference while I adapt the logic to the different structure of this file. My skills in Excel, Excel VBA, Visual Basic, and macro-based automation make me well suited to deliver a user-friendly solution. Choose me to turn this multi-tab workbook into a clear and efficient PDF-generation tool.
$20 AUD in 40 days
7.9
7.9

The key is to apply each PDF format without permanently changing your 60-tab workbook. I can use the working file as a reference, then build VBA for your workbook’s layout. Page 1 will have tab-selection checkboxes, a format selector, and an export button. The macro will gather the selected sheets in workbook order, apply the chosen heading and footer treatment in a temporary copy, and export only those sheets. I’ll also check print areas and page breaks, and handle cases where no tabs are selected. You’ll receive the macro-enabled workbook and brief usage instructions. I have a few questions: Q1. Will this run in Excel for Windows, Mac, or both? Q2. Should the coloured headings and footer appear in Excel’s print header/footer areas or within the worksheet content? To start, please share both workbooks and an example of each desired PDF format.
$20 AUD in 40 days
7.8
7.8

I am confident in my ability to assist with creating a control page in Tab 1 linked to different tabs with checkboxes and generating a custom PDF based on user selections. I can develop dynamic PDF generation functionality based on selected tabs while also implementing features like choosing different output formats for the PDF appearance. My expertise lies in designing VBA scripts that cater to unique workbook needs. I prioritize creating intuitive user interfaces with robust backend logic for scalability and future enhancements. Security measures like error handling and data validation will be implemented for a stable and secure application. I look forward to collaborating with you to exceed your expectations. Let's discuss timelines, integrations, and long-term goals for a successful partnership.
$17 AUD in 5 days
7.3
7.3

Hi, I’ve read your project description and understand that you need help creating an Excel control page that lets users select workbook tabs and an output format before generating a tailored PDF. I can help you achieve this by reviewing the working reference workbook and adapting its logic to your 60-tab document. I have experience in JavaScript and spreadsheet automation, including building an automated Google Sheets reporting tool that compiled data into formatted outputs. I focus on clear communication, attention to detail, and delivering work that meets the client's expectations. My approach: - Review both workbooks and map the tab-selection requirements. - Create the control-page selection workflow and PDF generation logic. - Apply the required Format A, B, and C heading/footer rules. - Test selected-tab combinations and provide updates or revisions if needed. I’d be happy to discuss your project and get started as soon as possible. Could you please confirm whether your existing working workbook uses Excel macros and whether each tab already has defined print areas? Thank you for your time. I look forward to working with you! Best regards, Teo
$25 AUD in 40 days
7.3
7.3

Hi, I can help you with "Excel Spreadsheet Coding Assistance -- 2" as per your given set of instructions. Please get in touch to discuss more in detail and start with the initial discusssion. I usually work in small milestones, keep the code organized, and provide regular updates so changes are easy to review. Let's discuss the current setup. I'll suggest the best implementation and an accurate timeline. ⭐ 5.0/5 from a recent client: "Nice work delievered again. Thank you" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
$18 AUD in 1 day
6.9
6.9

Hi there, I have read your project and understand that you need a flexible Excel VBA solution that allows users to select specific worksheets from a control page and export them into a PDF using their preferred format. First, I’ll review both workbooks to understand the existing export logic and adapt it to your current workbook’s structure. Then, I’ll build a checkbox-based selection system on Tab 1, with a dedicated button to export only the selected worksheets in the correct order. Next, I’ll add a format selector for Formats A, B, and C, applying the required heading and footer styles to the exported PDF without unintentionally altering the original worksheets. Finally, I’ll test different worksheet combinations and all three formats, handle cases where no tabs are selected, and provide clear instructions for using and maintaining the solution. Could you confirm whether each format should use the same page layout and margins, with only the headings and footer changing? I also have ideas for making the export system easier to extend as you add more worksheets or output formats. Please initiate a chat so we can discuss the technical requirements and next steps. Cheers, Aneesa
$15 AUD in 40 days
6.8
6.8

AVAILABLE TO START IMMEDIATELY. FREE SAMPLE PROVIDED.,,. I will develop a custom Excel VBA macro to create your Tab 1 control page with sheet-selection checkboxes and automate multi-tab PDF exports featuring dynamic header and footer formatting. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$15 AUD in 1 day
6.7
6.7

Hello, I'm Denis, a full-stack developer specializing in Excel automation. I've built tools that let users control complex workbooks through simple interfaces and generate formatted reports on demand. Your project: Turn Tab 1 into a control center where users tick checkboxes to select which of your 60 tabs to include in a PDF, then click a button to generate that PDF with custom formatting. The formatting choice—blue headings, no headings, or green headings with footer—should change the PDF appearance accordingly. Your reference file shows the overall approach, which will help me understand the logic despite structural differences. My approach: I'll review both workbooks to map the checkbox logic and understand how the existing file handles tab selection and PDF generation. Then I'll build the control page with checkboxes linked to your 60 tabs, create VBA code to collect selections and format choices, and write the PDF export routine that applies the right styling to each output. I'll test against your reference file's behavior and refine based on your feedback. Main challenge: Making PDF generation reliable across 60 tabs with different content while keeping formatting logic clean. I'll build a reusable formatting function that applies styles based on the selected format, so adding or changing formats later is straightforward. I'll test with sample tabs early to catch layout issues. I can start right away. Let's discuss the details. Thanks, Denis.
$15 AUD in 40 days
6.3
6.3

Hi there, I went through your project description and understand you need an Excel VBA solution that lets users select specific worksheets from a control page, choose a PDF output format, and generate a customized PDF with one click. I will review your existing workbook and the reference file to understand the current structure and working logic. Using Excel VBA, linked checkboxes or an equivalent selection interface, and worksheet export methods, I will build a control page that supports selecting individual tabs and exporting only those chosen. I will also implement the three formatting options, applying the appropriate heading colours, removing headings where required, and adding the green footer for Format C. The code will be organized, commented, and designed to accommodate additional worksheets and formats later. I will test different worksheet combinations and output formats to ensure the exported PDFs match the selected settings. I will share a project blueprint within 24 to 48 hours of being awarded the project. To scope your project clearly, could you confirm whether the three PDF formats should change only headings and footers, or also page layout, margins, and other formatting? Let's discuss your workbook structure and establish the best approach. Kind Regards, Imran Ali
$15 AUD in 40 days
6.0
6.0

Hello, one detail in your post stood out: you already have a working file that does the tab-selection part, and the two workbooks are structured differently. That means the logic can be reused, but the sheet names, checkbox links and print areas have to be mapped carefully, or the PDF will pick up the wrong tabs or cut pages off. I would start by studying your working file to see how it builds the selection and export. Then I would build the control page in Tab 1 with a checkbox for each of the 60 tabs, linked to the matching sheet name, and a button running a VBA macro that gathers the ticked tabs and exports them as one PDF. For the format choice, a dropdown (A, B or C) would set the heading and footer colors on the selected tabs just before export, and then restore the originals, so your workbook stays unchanged afterwards. I would also check page setup and print areas on each tab so the output looks clean. Could you send both workbooks, and let me know whether the heading and footer should sit in the sheet itself or in the printed page header and footer? That decides how Part 2 is built. Thank you for your time, and I look forward to hearing from you. Kind regards, Juan Pablo
$20 AUD in 40 days
6.4
6.4

I’ll develop a **VBA-powered Excel control dashboard** with checkboxes linked to the relevant worksheets and an export button that generates a single PDF containing only the selected tabs. I’ll also add Format A, B, and C options to dynamically apply the required heading and footer styles before export, while preserving the original workbook structure. **Deliverables:** Worksheet selection controls, PDF export automation, conditional formatting for all three output formats, and testing to verify tab selection, layout, headers, footers, and PDF output. I’ll use your existing workbook as a reference for the logic and adapt it to the new document. Ready to start ASAP.
$15 AUD in 40 days
6.4
6.4

JavaScript and software architecture are central to building reliable workbook automation, and I can apply that experience to create the control-page logic your Excel document needs. Your project requires linked tab selections, a button-driven PDF export, and format-dependent presentation, all coordinated from Tab 1. I focus on clean, maintainable code and scalable business automation, which is important here because the workbook already contains around 60 tabs and must support multiple output formats without duplicating the selection logic. I can also use your existing working workbook as a reference while adapting the implementation to the different structure of this document. I would be glad to build this Excel workflow so users can select the required tabs and generate the appropriate PDF format from one control page.
$20 AUD in 40 days
5.8
5.8

==== Hi - Truong here ==== "EXCEL VBA SELECTIVE PDF EXPORT" - you need to select sheets and apply the right PDF format from one control page. I’ll adapt your working example to the new workbook, using VBA to export only checked tabs and apply the chosen heading and footer style without changing the original sheets. Can you share both Excel files? Looking forward to work with you.
$20 AUD in 40 days
5.6
5.6

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience working with Excel VBA, macros, and automated document generation, and I'm available to start your project right now. In my opinion, one of the key challenges is exporting only the selected worksheets into a single PDF while applying different formatting options without modifying the original workbook. I'll use Excel VBA to create a control page with checkboxes linked to your 60+ worksheets and a button to generate the PDF. I'll also implement Format A, B, and C using configurable headers, footers, and colors. The macro will handle worksheet selection, page setup, and PDF export while preserving the original sheets. I can review your existing working Excel file as a reference and adapt the logic to the new workbook structure. I have a couple of quick questions. • Should the selected worksheets appear in their original tab order? • Should the formatting apply only to the exported PDF? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos.
$15 AUD in 40 days
5.9
5.9

Hey, setting up that control page to loop through your selected sheets and export a clean PDF is totally doable. I can write a quick VBA macro that reads your checkbox states, applies the format changes to the headers and footers on the fly, and bundles the result into a single PDF. Since you already have a working reference file, adapting that logic will save us a ton of time. Are the 60 sheets all standard worksheets, or are there any chart tabs in the mix?
$20 AUD in 40 days
5.9
5.9

I can do it now. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$20 AUD in 40 days
6.1
6.1

Hi, The main risk is preserving each sheet's layout while applying temporary format variations and exporting only the chosen tabs from a 60-tab workbook. That requires a deterministic mapping between checkboxes on Tab 1 and sheet print areas, safe application and rollback of Format A/B/C styles, and reliable PDF assembly so users get exactly the selected pages in the chosen appearance. I have built multi-component business systems including a payroll API and a mission-critical tax filing system, and I regularly create Excel automation for complex reporting and PDF generation. I can use your working workbook as a behavioral reference and adapt its logic to your different structure without copying code blindly. I will keep changes minimal and document every VBA routine I add so you can review or extend it. I will start by inspecting both workbooks, then implement a control area on Tab 1 that stores the checkbox-to-sheet mapping and a format selector. The export will be a VBA routine that collects selected sheets, applies temporary header/footer/format adjustments per Format A/B/C, exports to a single PDF, and restores original sheet styles. - Would you like checkboxes as Form Controls or a UserForm for selection? - Do the formats need to change content (heading text) or only appearance (color and show/hide)? Regards, Thomas Beigbeder
$25 AUD in 1 day
5.5
5.5

I will automate your Excel spreadsheet coding using optimized VBA macros and Power Query M scripts to deliver fast, error-free data processing. I structure modular subroutines, disable screen updating during execution, and enforce strict error handlers to prevent Excel freezing, calculation lag, and broken cell references. Are you targeting Windows desktop Excel using VBA macros, or Excel for Web using TypeScript Office Scripts? Best Regards, Waqas
$21 AUD in 40 days
5.5
5.5

Sydney, Australia
Payment method verified
Member since Aug 27, 2026
$30-250 AUD
$30-250 AUD
$50-100 USD
$10-30 USD
$15-25 AUD / hour
₹12500-37500 INR
$750-1500 USD
₹2500-5000 INR
$1500-3000 USD
₹12500-37500 INR
min ₹2500 INR / hour
₹750-1250 INR / hour
$50-100 USD
₹1500-12500 INR
$15-25 USD / hour
$15-25 USD / hour
€30-250 EUR
₹12500-37500 INR
$30-250 USD
₹1500-12500 INR
₹1500-12500 INR
£80-150 GBP
$50-100 USD