Cleaning excel data and putting in table using macros/VBA
$30-100 USD
已关闭
已发布大约 15 年前
$30-100 USD
货到付款
Using VBA in Excel, need to do the following to long lists of? raw? data copied and pasted? from a website:
1) remove empty rows
2) remove unwanted text from row values
3) remove duplicates
4) complete series of "if, then" tests to create? several? columns containing the below data, data which is currently in only one column:
? ? ? ? a) product name
? ? ? ? b) product weight
? ? ? ? c) indicate if special promotion
? ? ? ? d) price
## Deliverables
I? can send? an excel file with examples of the raw data.?
You could write the VBA code directly in this file.