Data manipulation - update table GUI

I need someone to perform some data manipulation automation. Here’s what needs to be accomplished: 1) Take the attached file titled [login to view URL] and [login to view URL] and manipulate data and put the manipulated data in the file titled Ama [login to view URL] (tab delimited text file) 2) Here’s the manipulation that needs to occur to the Ama [login to view URL] file - rows 1 and 2 in Ama [login to view URL] cannot be changed and need to stay the way they are - only items that are in both [login to view URL] and [login to view URL] need to be placed into Ama [login to view URL] - Any item that is in [login to view URL] and NOT in [login to view URL] needs to be ignored - The date from the source files [login to view URL] and [login to view URL] map to the target file Ama [login to view URL] using the mapping provided below. In the case of there is not matching columns in the source files, use the mapping from the Static Data in the attached file titled data mapping. I have only included a subset of my records in the source files. The manipulation should work on upto 30000 records. In the target file Ama [login to view URL] if I have not listed any mapping above it needs to be blank. This is a very simple mapping request. Please take a look at all three files (in excel as I find it easy that way). What I am looking for is a GUI that will let me click a button and the above manipulation will occur and be saved in the target file Ama inv.txt. I do not want to open multiple files to do this. I want an automated solution that will do this for me. Some background: The data in [login to view URL] changes only about three times per year. However the data in [login to view URL] changes on a twice daily basis. Thus, I need to be able to upload my data file Ama [login to view URL] about 2 to 3 times per day. PRICE MANIPULATION If [login to view URL] is less than or equal to 5 then Ama inv.item-price = [login to view URL] + 3 If [login to view URL] is greater than 5 and less than or equal to 10 then Ama inv.item-price = [login to view URL] *1.16 + 3 If [login to view URL] is greater than 10 and less than or equal to 50 then Ama inv.item-price = [login to view URL] *1.16 + 2 If [login to view URL] is greater than 50 and less than or equal to 80 then Ama inv.item-price = [login to view URL] *1.16 + 1.5 If [login to view URL] is greater than 80 and less than or equal to 200 then Ama inv.item-price = [login to view URL] *1.14 + 0.5 If [login to view URL] is greater than 200 and less than or equal to 400 then Ama inv.item-price = [login to view URL] *1.13 + 1.5 If [login to view URL] is greater than 400 then I do not want to sell this item and thus Ama inv.item-price 9999.99 and Ama [login to view URL] = 0 QUANTITY MANIPULATION If Dbl_approved_items.qty_available 10 and 20 and 30 and 50 THEN Ama [login to view URL] = Dbl_approved_items.qty_available WEIGHT MANIPULATION If [login to view URL] (round to zero decimal placed and add 3) > 20 then Ama [login to view URL] = 0