Use an autofiltercustombegins with from DataFilter.

When you have the filtered list, hit F5SpecialVisible cells only.

Copy those.


Gord Dibben MS Excel MVP

On Wed, 8 Nov 2006 08:51:02 -0800, john mcmichael
wrote:

I am running a search ( FIND ) that finds all cells in a spreadsheet that
part numbers that begin with the letters PB. I would like to select these
cells and copy them. I don't see any way to select the results of my search.
Is there a way this can be done?

Thanks for any help you can provide. :)