software

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.

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 Datagt;Filtergt;AutoFilter. Use the drop down box on
Shipment date and then select custom and you can apply the filter that you
wish to use.

Ian

quot;yetshinquot; wrote:

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

ya i tink tat will do when i add another column of quot;monthquot; beside my quot;datequot;
column, and fill in all the month accoding to the date, then do the auto
filter to the quot;monthquot; column. but my data are all in date form, eg. 21-Mar-06,
12-Dec-06, etc. then i not sure custom can do tat.
thx.

Ian P wrote:
gt;Macros will do this but have you tried using filter. If your worksheet has
gt;all of the shipment dates in one column then this should work fine. Select
gt;the column headers and the Datagt;Filtergt;AutoFilter. Use the drop down box on
gt;Shipment date and then select custom and you can apply the filter that you
gt;wish to use.
gt;
gt;Ian
gt;
gt;gt; i have many data of shipment date of some products, the shipment date may
gt;gt; from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show
gt;gt; those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me
gt;gt; can use macro to make it but i can't figure out how to do.
gt;gt; thx very much.

as ian say's work fine here try it, i dont think u have to ad any column's :-)

quot;yetshinquot; skrev:

gt; ya i tink tat will do when i add another column of quot;monthquot; beside my quot;datequot;
gt; column, and fill in all the month accoding to the date, then do the auto
gt; filter to the quot;monthquot; column. but my data are all in date form, eg. 21-Mar-06,
gt; 12-Dec-06, etc. then i not sure custom can do tat.
gt; thx.
gt;
gt; Ian P wrote:
gt; gt;Macros will do this but have you tried using filter. If your worksheet has
gt; gt;all of the shipment dates in one column then this should work fine. Select
gt; gt;the column headers and the Datagt;Filtergt;AutoFilter. Use the drop down box on
gt; gt;Shipment date and then select custom and you can apply the filter that you
gt; gt;wish to use.
gt; gt;
gt; gt;Ian
gt; gt;
gt; gt;gt; i have many data of shipment date of some products, the shipment date may
gt; gt;gt; from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show
gt; gt;gt; those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me
gt; gt;gt; can use macro to make it but i can't figure out how to do.
gt; gt;gt; thx very much.
gt;