Data Entry: Macro / Excel / VBscript /C / C#
$30-40 USD
Πληρώθηκε κατά την παράδοση
So, I need the following:
**Combining/Calculation:**
1) The script to go through the SKU column (A)
2) take items with the same SKU
3) combine the options for this SKU (column B)
4) calculate the price differences and put price differences (+/-) next to the option
5) Just copy and pasted SKU/Price for tems in a single row (not available in other finishes/options)
The output needs to be in 2 separate formats:
**Sheet 2:**
1) Take the header for column B and present as ***!Select header name!*****Select header name;***
2) display options separated by a semicolon
3) display price difference as **=+** or **=-
** 4) NOTE: no spacing before equal sign, before/after semicolon or other puncuation**
**
**Sheet 3:**
1) Take header column and display as
"Select Header Name"
"Select Header Name"
2) Display options in quotes separated by line-break in the cell (ALT/ENTER)
3) Display price difference in parentheses with dollar sign. For example (+$10)
**
**4) NOTE: EACH OPTION OR HEADER NAME MUST BE IN QUOTES AND SEPARATED BY A LINE-BREAK IN THE CELL
PLEASE SEE SAMPLE EXCEL TO UNDERSTAND THE PROCESS. SHEET 1 IS THE ORIGINAL DATA PROVIDED BY VENDOR. SHEET 2 AND SHEET 3 ARE THE FINAL PRODUCT, AFTER COMBINING OPTIONS/CALCULATING PRICE DIFFERENCE/FORMATTING.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement).
## Platform
MS ACCESS, VB, MACRO, EXCEL
Ταυτότητα Εργασίας: #3303161