No dupes
 

I am trying to get all the date from a certain date and I think I need to use
the no duplicates but am not sure what the macro would look like.

I have 50 rows of material some with the same date but not all.

Column A B C
5/12 100 50
5/12 95 55
5/13 100 40
5/13 98 42
5/13 97 45
5/18
6/15

I need all the information the date 5/13.

Can anyone help .... thank you in advance.

Eric

No dupes
 

Try using
datafilterautofilterfilter the column and date desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
I am trying to get all the date from a certain date and I think I need to
use
the no duplicates but am not sure what the macro would look like.

I have 50 rows of material some with the same date but not all.

Column A B C
5/12 100 50
5/12 95 55
5/13 100 40
5/13 98 42
5/13 97 45
5/18
6/15

I need all the information the date 5/13.

Can anyone help .... thank you in advance.

Eric

No dupes
 

Don,
In this case I don't think I can do it. I am going to be copying the cells
over to another sheet. For example if I was search for date 5/13 and found
it in rows 3,4,5,and more, I would copy all the row over to sheet called
sheet"A".

I have made it work with other no dupe macros but for some reason it isn't
working with the date?

"Don Guillett" wrote:

Try using
datafilterautofilterfilter the column and date desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
I am trying to get all the date from a certain date and I think I need to
use
the no duplicates but am not sure what the macro would look like.

I have 50 rows of material some with the same date but not all.

Column A B C
5/12 100 50
5/12 95 55
5/13 100 40
5/13 98 42
5/13 97 45
5/18
6/15

I need all the information the date 5/13.

Can anyone help .... thank you in advance.

Eric

No dupes
 

If desired, send your file to my address below along with a snippet of this
msg on an inserted sheet and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Don,
In this case I don't think I can do it. I am going to be copying the
cells
over to another sheet. For example if I was search for date 5/13 and
found
it in rows 3,4,5,and more, I would copy all the row over to sheet called
sheet"A".

I have made it work with other no dupe macros but for some reason it isn't
working with the date?

"Don Guillett" wrote:

Try using
datafilterautofilterfilter the column and date desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
I am trying to get all the date from a certain date and I think I need
to
use
the no duplicates but am not sure what the macro would look like.

I have 50 rows of material some with the same date but not all.

Column A B C
5/12 100 50
5/12 95 55
5/13 100 40
5/13 98 42
5/13 97 45
5/18
6/15

I need all the information the date 5/13.

Can anyone help .... thank you in advance.

Eric