Macros will do this but have you tried using filter. If your worksheet has
all of the shipment dates in one column then this should work fine. Select
the column headers and the DataFilterAutoFilter. Use the drop down box on
Shipment date and then select custom and you can apply the filter that you
wish to use.

Ian

"yetshin" wrote:

i have many data of shipment date of some products, the shipment date may
from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show
those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me
can use macro to make it but i can't figure out how to do.
thx very much.