Modify existing excel and excel macro files
Budget: £10 – £75 GBP
I have requests on 4 different files. They should be fairly simple as most are removing or reordering bits of current macros.
1.) Master Availability Weekly List 2022.xlsx
I email this file to lots of people, it works well but I have issues with Apple macs. I believe it is some of the calculations, particularly on the “Summary” tab, the calculation to ensure it only shows the rows with data in them. Do you have a better idea of what formulas could be used to work on a Mac?
2.) Mailer Program Generate Availability V3.18.xlsm
2a.) Remove the functionality of 5.) compare live links and the button
2b.) Rearrange the buttons, the order should be 1, 6, 4, 2, 3. Obviously once reordered please renumber them to make it logical.
2c.) The the run all button should be in that order too and also remove the functionality of 5.
3.) XML_Converter_v12.7.xlsm
This macro automatically prints a page when it processes the file. The program works well I just need it to NOT print the page.
4.) Process Internet Orders_v2.xlsm
4a.) Remove the part of this program that checks is stock is available, if it is NA or negative stock and do not change the date to when the stock is available. The date best to be todays date and then in the xml conversion best to remove that line of code.
4b.) If a stock code does not exist remove the line and just have a pop up “PRODUCT CODE Stock code does not exist on SPREADSHEET NAME” but obviould put the actual product code and spread sheet name in the test.
I will also send the supporting files required to test the above files to the winning bidder.
1.) Master Availability Weekly List 2022.xlsx
I email this file to lots of people, it works well but I have issues with Apple macs. I believe it is some of the calculations, particularly on the “Summary” tab, the calculation to ensure it only shows the rows with data in them. Do you have a better idea of what formulas could be used to work on a Mac?
2.) Mailer Program Generate Availability V3.18.xlsm
2a.) Remove the functionality of 5.) compare live links and the button
2b.) Rearrange the buttons, the order should be 1, 6, 4, 2, 3. Obviously once reordered please renumber them to make it logical.
2c.) The the run all button should be in that order too and also remove the functionality of 5.
3.) XML_Converter_v12.7.xlsm
This macro automatically prints a page when it processes the file. The program works well I just need it to NOT print the page.
4.) Process Internet Orders_v2.xlsm
4a.) Remove the part of this program that checks is stock is available, if it is NA or negative stock and do not change the date to when the stock is available. The date best to be todays date and then in the xml conversion best to remove that line of code.
4b.) If a stock code does not exist remove the line and just have a pop up “PRODUCT CODE Stock code does not exist on SPREADSHEET NAME” but obviould put the actual product code and spread sheet name in the test.
I will also send the supporting files required to test the above files to the winning bidder.