Excel Spreadsheet Macro
Budget: $30 – $250 AUD
Hi, we looking for a macro that will do the following:
1) Apply a price % increase to entire column D and round up to nearest 50c.
2) Change Effective Date to a specific date
3) Batch select folders/files to apply the macro to
4) Macro to save a copy of file with todays date in the file name into original files locations
5) Macro to lastly export a PDF version of the updated excel spreadsheet
Please only apply if you can do all of the above. Example file attached.
1) Apply a price % increase to entire column D and round up to nearest 50c.
2) Change Effective Date to a specific date
3) Batch select folders/files to apply the macro to
4) Macro to save a copy of file with todays date in the file name into original files locations
5) Macro to lastly export a PDF version of the updated excel spreadsheet
Please only apply if you can do all of the above. Example file attached.