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