Hi,

For instances like this, please use Advanced filters. They are very well
explained in the Help menu

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"GeorgeR" wrote in message
...
I have a worksheet of data that I would like to have the row contents
copied
to another worksheet if the contents of column O = "XX". This is done
several
times a week every week so I am not sure how to write the formula and save
it
so it is available to any open workbook. The worksheets are not a
consistent
size. They usually go from 300 to 1000 rows of data.
Any help would be appreciated.