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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]VM Name[/TD]
[TD]Mem[/TD]
[TD]vCPU[/TD]
[TD]Installed date[/TD]
[TD]Product No[/TD]
[/TR]
[TR]
[TD]vm1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2013-02-20[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm21[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm22[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm23[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2013-03-20[/TD]
[TD]222[/TD]
[/TR]
</tbody>[/TABLE]

The secound collection:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]VM Name[/TD]
[TD]Mem[/TD]
[TD]vCPU[/TD]
[TD]Installed date[/TD]
[TD]Product No[/TD]
[/TR]
[TR]
[TD]vm1[/TD]
[TD]222[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm5[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2014-11-24[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm21[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm22[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm23[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2013-03-20[/TD]
[TD]222[/TD]
[/TR]
</tbody>[/TABLE]

The thired collection:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]VM Name[/TD]
[TD]Mem[/TD]
[TD]vCPU[/TD]
[TD]Installed date[/TD]
[TD]Product No[/TD]
[/TR]
[TR]
[TD]vm1[/TD]
[TD]222[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2013-02-10[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm5[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2014-11-24[/TD]
[TD]111[/TD]
[/TR]
[TR]
[TD]vm21[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm22[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD]2013-03-10[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm23[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2013-03-20[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm24[/TD]
[TD]10[/TD]
[TD]4[/TD]
[TD]2014-11-24[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm25[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2014-11-24[/TD]
[TD]222[/TD]
[/TR]
[TR]
[TD]vm7[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2014-11-24[/TD]
[TD]111[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[Ziddo]

bump