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