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.