I have an excel sheet that has about 16,000 products, prices, pictures, categories and sub catagories I use to upload to my retail website. (Example 1)
I have another excel sheet (Example 2)formatted differently, that is updated quarterly that has the same part numbers (along with about 25,000 others) and new prices (costs). What I need to have happen, is the new updated costs to be minipulated and put into the retail column(For instance, if cost is 0 to $50 retail will=(cost+30%), $50.01 to $100=(cost +25%), $100.01 to $150= (cost +20%), so I can use the new retail prices I create to update (override) the current retail prices.
I would also like to figure out how to take any item of my choice, part#'s, descrition, picture, cost, retail price,catagory and sub catagory, and add it to my master file (Example 1) so that it can be uploaded to the website along with the new updated prices. The only difference would be the part # sequence would be different. We may need to add a new column that can be auto generated (with a new set of part #'s) based on criteria we give it (for catagory and sub catagory, This can be quoted seperately. Just make sure you are qualified to handle both parts.
Feel free to ask questions. It's very important we can communicate well in english.
101 freelancers are bidding on average $311 for this job
This can certainly be done using Excel VBA in which I have extensive experience. Please note that 4 days are just for the communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.