Count changes made in new tab and view the amount of the changes

[Ziddo]

Hi Excel experts,

I have a question regarding if this can be done or not and also I you have any better idéers how to do this.

We have an viriualization environment and we are collecting information and trying to view an resource picture to all departments that are using the environment.
We are sorting everything from product numbers.

So what I am trying to do is collecting a view of the resources and the change from time to time.
For example we want to count the number of VMs that an product number is using and the resources that they are using, but .... we also want to see if on the next collection what have been changed.
Are the number of VMs the same?
Are they the same VMs?
Have the resources increased?
Have the resources decreased?

Can this be done tru "pivot table"?


This is an example of how ouer table looks like.

The first collection:

VM Name	Mem	vCPU	Installed date	Product No
vm1	2	1	2013-02-10	111
vm2	2	1	2013-02-10	111
vm3	1	1	2013-02-20	111
vm21	2	1	2013-03-10	222
vm22	1	1	2013-03-10	222
vm23	1	2	2013-03-20	222

<tbody>
</tbody>

The secound collection:

VM Name	Mem	vCPU	Installed date	Product No
vm1	222	1	2013-02-10	111
vm2	2	1	2013-02-10	111
vm5	1	5	2014-11-24	111
vm21	1	1	2013-03-10	222
vm22	100	1	2013-03-10	222
vm23	1	2	2013-03-20	222

<tbody>
</tbody>

The thired collection:

VM Name	Mem	vCPU	Installed date	Product No
vm1	222	1	2013-02-10	111
vm2	2	1	2013-02-10	111
vm5	1	5	2014-11-24	111
vm21	1	1	2013-03-10	222
vm22	100	1	2013-03-10	222
vm23	1	2	2013-03-20	222
vm24	10	4	2014-11-24	222
vm25	5	3	2014-11-24	222
vm7	1	1	2014-11-24	111

<tbody>
</tbody>

Thanks a lot if you have a idéer on how to solve this.

 

[Ziddo]

bump