I am after a bit of VBA for excel written up that will:
On click of a button:
- Refresh the following data sheets:
------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.
8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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.