Hi Denise

You can use this add-in if you not want to use code
http://www.rondebruin.nl/easyfilter.htm

Or use the code on this page
http://www.rondebruin.nl/copy5.htm



--

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


"DeniseCost" wrote in message ...
I am trying to make a macro which cuts and pastes lines into a new worksheet
within the workbook when certain cells are populated with a "Y"...NEver wrote
Visual Basic code, only used recorded macros and the 'wizards' within
access..Thanks!