Closing Stock Report With Parameters

[Prabhu]

Hi Friends,

I needs to Identify the Closing stock based on part numbers from the Purchase and sales transactions .

And then i need to identify the closing stock which is lying over 60 days in the inventory.

Example:

I purchased Part number "XYZ' 70 Nos on 1of Jan'11and 30 Nos on 15th of Feb'11
Sold 60 till 31st march '11 and balance 40 nos on 31st March 2011. In that 40 Nos 10 nos over 60 days stock

I have attached sheet which contains purchase and sales sheet with Summary which we needs to prepare.
I have taken 3rd Sep 2011 is Base date in this working.

can anybody help to get VBA code for preparing Summary sheet!

Pzl revert back if you have any doubt on this.

Regards,

Prabhu