"Jim May" <jmay@cox.net> wrote in message
news:VBWse.65451$Fv.7255@lakeread01...
> Small Sample...
>
> Sheet1Range A1:C6
> Code Amt Dup?Sheet2
> abc 1,123.00 Y
> cds 1,234.00 Y
> vvv 1,345.00 N
> bb 1,456.00 Y
>
> Apply Data, Auto-Filter on C1 = Y
> to get:
> Code Amt Dup?Sheet2
> abc 1,123.00 Y
> cds 1,234.00 Y
> bb 1,456.00 Y
>
> Highlight selection and COPY;
>
> Move to Sheet2
> and in A1 Edit, Paste-Special
> Click the "Paste-Link" Button
>
> It's a start --- Maybe?????

Jim,

Thanks for this. Unfortunately I'm not as skilled as you are and don't
readily follow your post.

Firstly, are you telling me to enter the following into cells?
> Sheet1Range A1:C6
> Code Amt Dup?Sheet2
> abc 1,123.00 Y
> cds 1,234.00 Y
> vvv 1,345.00 N
> bb 1,456.00 Y

i.e., into A1 I would put *Sheet1Range A1:C6*
into B1,B2,B3 *Code Amt Dup?Sheet2*
and the other items into 4 rows in 3 columns beneath?

Rob