Comparing two columns in different excel sheet and post the result in third sheet along with some columns from 1st and 2nd sheet

Hey Guys..

In the 1st sheet I have three columns ->product name ,page views and unique page views.

In 2nd sheet I have 6 –> columns prodcut name ,sku,category,brand,sales value,sales qty,

I need to make a 3rd sheet which will have product name column from 1st and 2nd sheet.(They have same prodcut but in random order).Also the 3rd sheet should pick corresponding page view and unique pageview(from sheet 1) and sku,category,brand and sales value and sales qty (from sheet 2) and post it in 3rd sheet.

I need to do VBA coding on the command button click event

Please help.I am new in excel and need to finish it.

 

By: Anshuman Sharma

3 thoughts on “Comparing two columns in different excel sheet and post the result in third sheet along with some columns from 1st and 2nd sheet

  1. Anshuman Sharma

    Yes.
    The product names are arranged randomly but they are same.
    I want them to be together so that they are in one column along with other columns like page views , unique page views sku,category,brand,sales value,sales qty.

  2. Sergiu

    Hi Sharma!
    Is your your issue solved ? I have a similar one and I have no clue how to fix it.
    Please help!
    Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *