Combine data of two dataset in one table

Hi,

I send this for some days a go
http://www.excelforum.com/excel-char...owerpivot.html

I have thought it over, I believe I was in wrong way.

I believe this is VBA problem, see the attachment file.

My problem is this,
I have two dataset, I have to cobine these two datasets
I dont' know what products will appear ( I have to use data1 and data2 to find out what products are in the tables)

I have made some demo in attachment file.DataProblem.xlsx

Try the attached. The numbers will not appear in order as per your sample, simply to avoid the Ifs statement, but if you want in order, I need to change the code. You need to test it on actual data.

Thanks for your patience.
I tried to actual data, but it didn't worked out (as I hope)

Maybe I was not precise. I have made some changes to my workbook.
I have data in sheet data 1 and data 2.

I have to take row A in data 1 and row A in data 2. Delete duplicate values.
The result will appear in Combine sheet, row A. I VBA for this part.

In coulmn H in sheet combine, I can use sumifs based on column A in sheet combine, however VBA would be great for that part.

Try the attached.

Great, thats works,
Thank you.