Dear all,

How to use macro or other convenient methods to sort out
the specified date?

For example:

Location part-no. Date
A1 637A 10-May-2004
B1 807K 12-May-2004
B2 639A 12-May-2004
C1 807K 12-May-2004
C5 639A 15-May-2004

The above example is a simplified data, assume that I
just want to find out and show the data which date is 12-
May-2004. I have to do the same things everyday to sort
out data of different date, so how can I just press one
button(set marco) or other methods to have this result.

Select a cell in the range and then activate the
AutoFilter featu
Data|Filter|AutoFilter

Regards,
Greg

-----Original Message-----
Dear all,

How to use macro or other convenient methods to sort out
the specified date?

For example:

Location part-no. Date
A1 637A 10-May-2004
B1 807K 12-May-2004
B2 639A 12-May-2004
C1 807K 12-May-2004
C5 639A 15-May-2004

The above example is a simplified data, assume that I
just want to find out and show the data which date is 12-
May-2004. I have to do the same things everyday to sort
out data of different date, so how can I just press one
button(set marco) or other methods to have this result.
.