Excel VBA Macro for Dynamic PDF Generation
Budget: $50 – $100 USD
I need an Excel VBA expert to help fix an issue with my workbook. The setup includes:
• A data entry sheet where users can input information.
• A second sheet that should automatically convert to a PDF.
• The PDF must be dynamically saved using the value in cell C3 as its file name.
• Only the data entry sheet should be visible to users.
Currently, I'm facing Error 1004 and the generated PDF always ends up with the same file name. I need the macro updated or rewritten to resolve these issues.
Deliverables:
• A working VBA solution that converts the specified sheet to PDF with the correct, dynamic file name taken from cell C3.
• Implementation of a button on the data entry sheet to trigger this process.
• Appropriate error handling to resolve Error 1004 and any other potential issues.
Timeline and Budget:
I'm new to these projects, so I'm open to suggestions on timeline and budget. Please provide your recommendations along with your proposals.
• A data entry sheet where users can input information.
• A second sheet that should automatically convert to a PDF.
• The PDF must be dynamically saved using the value in cell C3 as its file name.
• Only the data entry sheet should be visible to users.
Currently, I'm facing Error 1004 and the generated PDF always ends up with the same file name. I need the macro updated or rewritten to resolve these issues.
Deliverables:
• A working VBA solution that converts the specified sheet to PDF with the correct, dynamic file name taken from cell C3.
• Implementation of a button on the data entry sheet to trigger this process.
• Appropriate error handling to resolve Error 1004 and any other potential issues.
Timeline and Budget:
I'm new to these projects, so I'm open to suggestions on timeline and budget. Please provide your recommendations along with your proposals.