Coder needed for Excel Spreadsheet / Macro / Based on SKU copy certain cells to the right column, Lahore

Deal Score0
Deal Score0

Job Posted: 26.02.2021 19:03:48

Hi there! I’m looking for someone to help create an excel spreadsheet where I’m able to import data from other excel files. The first file that I would like to view is ‘Listings’: I would like the data to be processed by SKU. The documents I will be importing are not in the correct SKU order. It should be A-01,A-02,A-03,A-04,A-05,A-06,A-07,A-08,A-09,A-10, ect… Going down as well as other SKU numbers and letters if I choose to add on. The order doesn’t matter but the final product the data must be linked to the correct row. Ideally once this has been processed. I would want to copy the "Titles", "Quantity" and the "Listed Price" onto the same row into the designated areas. After this I would want the option to remove this information if the quantity is ‘0’ with a button. I would like this all done on Excel. This is so that I am able to track what has sold and what is currently listed. I would also want an option to link another spreadsheet called ‘Solds’ which would go through and update the final sold price as well as move the data to another sheet. I would want to copy the actual SKU, not move it. And then move the "Title", "Quantity", "Price", "Cost" and "Paid on Date". I would like the information highlighted stored on the sheet. Finally, I would like the option to track Unlisted inventory on another sheet by removing any listed items/sold. Everything should be kept separate yet tracked. I have attached pictures of the spreadsheet so far as well as the files I would like to add.

Project Length:

1 to 3 months

Hours Needed:

null

Fixed Price:

30

To start you need register at Upwork, apply now. Its free!

This and other jobs await your proposal.

We will be happy to hear your thoughts

Leave a reply