I need to copy data from sht 1 to sht 2 according to specific crit

[Dbl_Planker]

I have a data sheet (sheet1) that is updated every couple of weeks. The
column information is A) stock #; B) Description; C) Weight; D) Price; E)
Entered Date. My data sheet contains information that now contains multiple
enter dates( 200+ rows of information).

I need to copy only the data specific to a selected date and paste it into a
template (sheet 2) Sales Sheet. I need to have the data arranged (sorted by
stock # and then by price). I'm hoping this can be done via formula but if
necessary code will work. I am not very experienced in using code.

exaple data (Data Sheet)

Stock # Description Weight Price Enter date
101 item 101 100 .05 6-10-09
102 item 102 50 .025 6-10-09
103 item 103 65 .35 6-10-09
101 item 101 85 .055 6-11-09
107 item 107 110 .85 6-11-09
--

Sales Sheet
Date - 6-11-09
Itme Description Weight Price
101 Item 101 85 .055
107 item 107 110 .85


Thank you and best regards,
Greg

 

[Don Guillett]

You can do this manually by data>filter>autofilter>filter on the date colum
for the desired date>copy>paste>sort. I would use a macro. If all else fails
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[Dbl_Planker]

Thank you. I'll try a macro recorder to see if I can pull and sort the data I
need. I'll let you know if this works. Thanks for your response.