No dupes

[Eric]

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

 

[Don Guillett]

Try using
data>filter>autofilter>filter the column and date desired

 

[Eric]

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]

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