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.

Evner: Excel

Se mere: code for website, editing and copy, quick excel, excel split data sheets, excel split sheet sheets, excel split sheet, excel copy data excel file, 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, copy data sheet sheet excel file, replace website website

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

Projekt ID: #952865

Tildelt til:


I will try my best.

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

4 freelancere byder i gennemsnit $40 på dette job


Please check PMB for details, Thank you

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


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

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

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