Completed

Modify two macro enabled excel files

I need a couple of simple modifications from my current programs. I would like them done ASAP so ideally within a day, maximum 2 days.

Prepare availability list:

Using the current program “Prepare and email Weekly [login to view URL]”

Currently if a cell = “NA” it locks the cell. I want it to lock the cell if it:

= “NA” or

starts with “20” or

= “TooTall”

I believe the part of the code that needs changing is this part:

If [login to view URL](i, j - 4).Value = "NA" Then

[login to view URL](i, j + 1).Locked = True

Convert the order to xml:

The program “[login to view URL]” converts my orders to xml but I have modified the spread sheet so the xml code needs to change.

The new code should use cells B2 to B13 in the xml code and the price in column E has been added into the xml code. See “Fragile Delivery Availability List [login to view URL]” for an example of the code which should be generated from “Fragile Delivery Availability List [login to view URL]”

The order now starts on line 20 whereas it used to start on line 14 (I don’t know if this matters).

<OrderNumber> = This is the Account number then the order number in B2. If cell B2 is blank use the same logic as current code.

<DeliveryNet> = Cell F15

<ItemNet> = column E

Added errors to report.

Keep the current errors it reports but also if any of the fields in yellow are blank have a pop up to say the file name and what the issue is. So for example if the account number and the town were blank, a pop up to say:

File Fragile Delivery Availability List [login to view URL] has the following errors:

Account number is blank

Town is blank

With the same “Do you wish to continue box”

Skills: Excel, Excel Macros, XML

See more: macro update log files status excel sheet, calculation sheets different excel files macro, clean excel files macro, how to enable macros in excel 2018, how to save a macro in excel for all workbooks, how to share an excel macro with another user, how to enable macros in excel 2013, how to edit a macro button in excel, how to enable macros in excel, how to copy excel macros from one pc to another, how to save macros in excel permanently, excel macro export text files, excel macro import project files, copy specific excel files folder folder macro, print excel files macro, excel macro check excel files directory, macro find replace excel files, excel macro find records files, macro excel text box number, macro merge excel files folder sheet

About the Employer:
( 12 reviews ) Enfield, United Kingdom

Project ID: #24415235

Awarded to:

kirilnberezebko

Hi . I have read your job description carefully. I have full experience in excel macro and vba. If you give me a chance, I will deliver good result. I hope to discuss more via chatting. Thank you.

£100 GBP in 1 day
(1 Review)
2.4

5 freelancers are bidding on average £126 for this job

cgullapalli

HI, I am good at Excel and Macros. I have followed the instructions provided in the description. Looking forward to discuss further in the chat and work on the project. I will possibly complete in one day and meet yo More

£150 GBP in 2 days
(862 Reviews)
8.0
fatimatuzzohura

Hi, I am specialized in data analysis and process improvement. I have experience in application development in Excel with VBA Macros, web development with Python, MySQL databases, and dashboard development with Tableau More

£150 GBP in 2 days
(136 Reviews)
6.3
ravinderkumar248

Hello. Good to see that you are looking foe excel VBA developer . i would like to help you in your work. I have 10+ years of experience in Excel VBA, creating complex automation tools, formulas, databases, queries and More

£150 GBP in 3 days
(22 Reviews)
4.6
webanis

Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am su More

£80 GBP in 2 days
(22 Reviews)
4.1