Hi,
Appologies if my title isnt clear but i cant describe what i want t
do! I have a large spreadsheet with many rows and wish to extrac
certain details (all columns in a row) if a specific feature is foun
in the rows.

The feature i am looking for is that if h4..h5..h6.. etc has 'a' or 'b
or 'c' then i want the entire row of 4,5,6etc to be copied into a ne
sheet..giving me a new sheet containing all the details for the row
that contained an 'a' 'b' or 'c'.

I wish to automate this by using a button but have no idea where t
start... please please help me ow wise ones!



--
jagbabbr
-----------------------------------------------------------------------
jagbabbra's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52307