Originally, I meant to say Sheet1Range A1:C5 << The reference to
Sheet1RangeA1..
was not intended to be entered into the sheet.
Does that help.


"Rob graham" <rttgrahamwow@btinternet.com> wrote in message
news:d94n5l$jq4$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
>
> "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
>
>
>