Extracting particular data from worksheets

[krishgi]

I have got data in no of worksheets in a excel file. For each day, data is summarized in columnar way as follows


Product Sales (units) Inventory (units) Sales (value) Inventory (VALUE)

A 20 10 2000 900B 5 15 1000 800
C 100 50 500 200


I have got data on a daily basis in a seperate sheet. I want to clear a summary sheet for the month where I want to show the above data for each product on a daily basis. How do I extract the data for each product in a summary sheet . The sheet should update based on the product reference

[Roger Govier]

Hi

It is not clear from your description, either how your data is ladi out, or what it is that you want to summarise.

Are the Data shown 3 rows from a daily sheet?
Is there a column before those shown, with a Product Id (a, B, C)?

Can you post a sample file showing waht it is you want to achieve?