The part numbers you will be looking for - how
widespread are they within a given worksheet?
Are they isolated to just one column?

anyway, you could loop through the range
and read all part numbers that begin with "PB"
into an array; Then you could write the array
values out to a new spreadsheet.



"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. :)