Hi, new here.

I'm hoping some of you can help me out on this problem i have.

I have one summary worksheet displaying data from 10 other worksheets. The summary will display daily stock movements. The other 10 worksheets containing the individual part's daily movement.

The problem i have is: how do I select the data of the day i want from each of the 10 worksheets to be displayed in the summary worksheet?

Eg. Today's (3/8/2006) Part A movement is selected and displayed in the summary. Tomorrow, Part A movement is again selected and displayed in the summary. Difference though is that in the individual part worksheet, data from 3/8/2006 and subsequently must be retained.

Thanks a whole lot.