do auto filter for <bob and highlight filtered data and copy to another
sheeet
create a macro doing these operations.

later you an modify the macro to make it general

=================================
countryfan_nt
wrote in message
news:countryfan_nt.1rviig_1120863905.7833@excelfor um-nospam.com...

Well, say I want to see all the data that refers to Bob. I want a macro
that will pick rows that start with Bob and copy it and and paste it in
sheet 2.


--
countryfan_nt
------------------------------------------------------------------------
countryfan_nt's Profile:
http://www.excelforum.com/member.php...o&userid=11051
View this thread: http://www.excelforum.com/showthread...hreadid=385422