Data Entry/Processing Macro

Simple task!

Create a excel macro that translates data from [url removed, login to view] to [url removed, login to view] as attached.

1) In the [url removed, login to view] file, there are three headers. "attribute:a_caacity" carries information of the size and variations of the product name (post_title).

2) For every size and variations, a row must be created in the result file as shown in the [url removed, login to view] file. In the result file, you have to match the following columns in the [url removed, login to view] file to the result file:

post_title -> Parent

post_parent -> post_parent

For all other product:

attribute:pa_capacity -> meta:attribute_pa_capacity

For skincare product:

attribute:pa_capacity2_skincare -> meta:attribute_pa_capacity2_skincare

3) As you can see in the [url removed, login to view] file, under attribute:pa_capacity you see fields like 50ml|75ml|75ml TESTER. This field means that the product ANNA SUI DOLLY GIRL EDT FOR WOMEN comes in 50ml, 75ml and 75ml tester. In the result file, I need you to form 3 rows like what you see in the [url removed, login to view] file. 3 rows for the product with the post_title and post_parent mapped over (from [url removed, login to view] file), one row for each size.

Note: If there is only one size, only 1 row is required for the result file.

4) Then input the size for the appropriate row in the column meta:attribute_pa_capacity in the result file.

5) Finally, I need manual data entry work from you to key in the prices for the respective product sizes. The result file will contain about 1800 rows.

Please PM the result file if you can do it.

Skills: Data Entry, Data Processing, Excel

See more: what is the data entry work, what is manual data entry, what is data input, what is a data entry form, what comes under data entry, one key data, data key entry, data input work, data entry macro, create excel form for data entry, create data entry form in excel, create a data entry form, work dolly, what is macro in excel, data entry means, simple macro, meta data, manual tester, manual data entry, macro, data entry processing, excel macro match data, excel macro row, excel macro csv, simple tester

About the Employer:
( 2 reviews ) Singapore, Singapore

Project ID: #2634101

Awarded to:


See your PMB

$50 SGD in 2 days
(18 Reviews)

10 freelancers are bidding on average $239 for this job


Thanks for your invite. Please check your PM

$150 SGD in 5 days
(29 Reviews)


$1500 SGD in 3 days
(54 Reviews)

Lets start..

$100 SGD in 1 day
(71 Reviews)

Excel / VBA pro - ten years experience.

$100 SGD in 3 days
(25 Reviews)

Expert Here. Please check P>>

$40 SGD in 2 days
(20 Reviews)

Please Check PMB for details.

$100 SGD in 2 days
(11 Reviews)

I have fully understood project details. I am built several scripts to automate the tasks. Let's start project.

$170 SGD in 2 days
(10 Reviews)

The macro is ready in 4-5 houres , and depends the data to complete I think 2-3 days. Yo'll have ready Sunday if yo're agree. Just contact me :)

$100 SGD in 3 days
(7 Reviews)

Sounds interesting!

$200 SGD in 5 days
(0 Reviews)

dear sir, i think i can do your job well with good finish. thanks

$50 SGD in 10 days
(0 Reviews)