View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GeorgeR GeorgeR is offline
external usenet poster
 
Posts: 13
Default Copy rows to another worksheet

THank you Ron

"Ron de Bruin" wrote:

Hi GeorgeR

Try this add-in
http://www.rondebruin.nl/easyfilter.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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.