Mr. MarvinP
I read your valuable suggestion. Let us more clear idea explain.

1] I have using this table life long.

2] From this table i calculting how many enquiries in quantity (Part number wise & datewise) we have receive from customer.?

3] From this data we have calculate monthly potential of particular Part number. How many quantity enquire from customer?

4] After that i m tried to how much quantity fulfill against enquire quantity? And how many quantity available in my stock on that particular date.

5] How many days we have not receiving enquiry & on that period how many quantity available in my stock.

6] I m tried to show all above data result in single sheet. (i.e. monthly summary report)

In view of above let me know the your valuable view. If possible post example file.