why not use
datafilterautofilterfilter for acopy

--
Don Guillett
SalesAid Software

"Nick" wrote in message
...
Hello,

I am running Excel 2003. Im trying to accomplish a lookup.

On sheet 1, in column A, I have values such as: A, B, C, D. These values
repeat themselves. A small example:

a date place
b date place
b date place
a date place
c date place

On my second sheet, we'll call it the "a" sheet, I want this sheet to
basically list only the cells that had "a" in column A from sheet 1. So I
would want to see on this sheet (using above example)

a date place
a date place

I've tried using VLOOKUP, but am getting strange results. I think it's
because the values repeat themelves ..but Im not sure.

Any help is greatly appreciated.