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