I gang

Quick Data Editing for Website options

I attached an xls file in a rar file.

In the excel file are 4 sheets. The “products” sheet had productcode and options_cloned_from column.

For each productcode check the options1 and options2 sheets for rows containing the same code as options_cloned_from. Copy all those rows to the sample sheet. You can leave out the id column.

Then on the “sample” sheet, replace the “applytoproductcodes” with “productcode” from the products sheet. I did 5 samples for you on “sample” sheet. The first options_cloned_from row on products sheet was not on options1 or options2, so I skipped it.

If you find an options_cloned_from on the options1 sheet, no need to check options2, they don’t have same codes. I just had to split options into two sheets as it was to many rows for XLS file.

Færdigheder: Excel

Se mere: quick excel, excel split data sheets, excel split sheet sheets, excel split sheet, excel split, website file find, website copy editing, excel column copy, replace excel row, copy data excel file, quick data, xls excel data, codes excel, check data excel file, copy replace, xls code, quick copy, productcode, find copy data website, products sheet excel, website excel file, column data excel, excel xls, excel copy sheets, copy website products

Om arbejdsgiveren:
( 120 bedømmelser ) Ashland, United States

Projekt-ID: #952865

Tildelt til:

BDspeed

I will try my best.

$35 USD på 1 dag
(160 bedømmelser)
6.1

4 freelancere byder i gennemsnit $40 for dette job

dataconsultants

Please check PMB for details, Thank you

$33 USD in 0 dage
(45 bedømmelser)
5.1
mujahiddar

LET STARTS>>>>>

$40 USD in 3 dage
(3 bedømmelser)
3.3
statnxt

Kindly refer to your Inbox for details and my proposal. Thanks!

$50 USD på 1 dag
(3 bedømmelser)
2.2