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.


--
cyc
------------------------------------------------------------------------
cyc's Profile: http://www.excelforum.com/member.php...o&userid=37047
View this thread: http://www.excelforum.com/showthread...hreadid=567760