If your not happy with Macro's then you could try 1 of the following:
1) Doing it manually.
Select your whole table.
Insert an autofilter.
In the Date column select the date you are interested in.
2) Pivot Table.
Select your whole table.
Data | Pivot Table.
Next.
Next.
Layout.
Drag Date to Page
Drag Prt # to Row
Drag Model to Row
Drag Qty to Data
Double Click on Prt # field change Subtotals to None. (This stops doubling up the lines)
Click OK
You can now change the Top (Page) drop down to the date of your choice and this will display the information you require.
3) Regarding the macro by Lenze.
Sub FilterDate()
'
' FilterDate Macro
' Macro recorded 9/13/2002 by lenze
'
Range("A1:D16").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"F1:G2"), CopyToRange:=Range("F4"), Unique:=False
End Sub
assuming your data is not in the format above.
Change the A1:D16 to include your entire Data table.
If you have a Target Date in cell Z2 make sure that the word Date appears in cell Z1 then change F1:G2 to Z1:Z2
Lastly if you want the output to appear in a table beginning in Z10.
Change the F4 to Z10.
_________________
Hope This Helps.
Sean.<A HREF= "http://website.lineone.net/~s-o-s/Index.html">
This message was edited by s-o-s on 2002-09-15 15:29