Copy Row based on a condition

[dennis.davis@gmail.com]

I have a worksheet that contains a lot of information from different
suppliers. I'm going to create a column that will get filled with an
"X" if we want to add that particular tool to our watch list. The
watch list will be another sheet in the workbook.

I want to copy the row where Column Z contains an "X" to the watch list
sheet.

Due to where I work, no one ever enables macros in workbooks so a macro
won't work for me. Is there a formula out there that will easily let
me do this? I've tried searching but haven't come up with anything
yet.

Thanks.

[Ardus Petus]

Try Data>Filter>Advanced filter

HTH
--
AP

<dennis.davis@gmail.com> a écrit dans le message de
news:1145450564.902591.97150@j33g2000cwa.googlegroups.com...
> I have a worksheet that contains a lot of information from different
> suppliers. I'm going to create a column that will get filled with an
> "X" if we want to add that particular tool to our watch list. The
> watch list will be another sheet in the workbook.
>
> I want to copy the row where Column Z contains an "X" to the watch list
> sheet.
>
> Due to where I work, no one ever enables macros in workbooks so a macro
> won't work for me. Is there a formula out there that will easily let
> me do this? I've tried searching but haven't come up with anything
> yet.
>
> Thanks.
>