Merge of two excel sheets

I have two lists of products that are different for code and price. I have to compare them and get a third list that as the list 1, but without the codes that we are on the list 2.

Then compare two excel sheets (1 of 4 columns SKU, DESCRIPTION, Price1, ID and 1 in 3 columns SKU, DESCRIPTION Rate2) and create a third sheet that is the union of the previous two.

The third sheet must:

- Have 4 columns (SKU, DESCRIPTION, Price1, Rate2, ID)

- If some SKUs are not on the list 1 list 2 leave all the other fields blank so that I can see which SKU is not in the list 1 list 2


lines should not mix but each SKU, DESCRIPTION PRICE ID and must bind to each other (the ID is linked to and SKU DESCRIPTION and PRICE)

tables have about 8000 lines one o'clock

fornisto the two lists. In response I would like an excel file that I can use in the future.


Beceriler: Veri İşleme, Excel, PHP, Visual Basic

Daha fazlasını gör: sheets, excel compare list columns, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, excel file columns, visual basic excel 2013, excel sheets merge, excel sheet merge, merge excel sheet, sku list excel, excel 2013 visual basic, merge sheet, products excel sheet, file excel compare, visual basic create excel sheet, codes excel, macro excel merge sheets, excel compare columns, itloffice

İşveren Hakkında:
( 30 değerlendirme ) Milano, Holy See (Vatican City State)

Proje NO: #4405147



Sir, I have read the project details very carefully and am ready to do the project. Please provide more information about the project so that I can get started. I can assure you that I will finish the work within the d Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(3 Değerlendirme)

Bu iş için 6 freelancer ortalamada $73 teklif veriyor


I've expertise to do that :)

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(80 Değerlendirme)

Excel Expert here...I have done many similar projects in past.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(77 Değerlendirme)

Hi, We're ready to take up your project. Kindly check PMB for more details. Awaiting your kind response.

in %bids___i_period_sub_35% gün içinde103%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)

hello sir let me finish this task for you :)

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

**** Please check PM. Thanks ****

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)

Sir, Please check PMB

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Dear Hiring Manager, Good day! You job post caught my attention and I truly feel that I am the perfect match for the job. I am an experienced virtual personal assistant and I can offer my great skills for your vir Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I can help you.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)