Thread: deleting rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
H.
 
Posts: n/a
Default deleting rows

Ron,

I do not have the rights to ad an add-in on every computer that is going to
use the workbook in question. So and ad-in is not an option. Thanks anyhow!

H.


"Ron de Bruin" schreef in bericht
...
Hi H.

Depend when your quarter start
EasyFilter have a option to do this
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"H." wrote in message
...
Have a sheet with some 500 rows.

Each row has in column A a date (ranging from januari 1 to whtever end
date but lets say december 31).
In the remaining columns are values I need belonging to the dates
(laboratory results to be more accurate) .
I need a macro that deletes all rows with a date NOT in quarter 1.

Think its easy, but I cannot make one that quick..... :-)
Who...?

thx
H.