macro
 

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.

macro
 

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.

macro
 

ya i tink tat will do when i add another column of "month" beside my "date"
column, and fill in all the month accoding to the date, then do the auto
filter to the "month" 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:
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

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.

macro
 

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

"yetshin" skrev:

ya i tink tat will do when i add another column of "month" beside my "date"
column, and fill in all the month accoding to the date, then do the auto
filter to the "month" 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:
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

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.