select cells that are the result of a search

J

john mcmichael

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

Jim May

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.
 
G

Gord Dibben

Use an autofilter>custom>begins with from Data>Filter.

When you have the filtered list, hit F5>Special>Visible cells only.

Copy those.


Gord Dibben MS Excel MVP
 
F

Farhad

That is right you can select the column that contains the part numbers and
then go to the menu: Data>Filter>Autofilter and then open the autofilter
combo box and choos custom and then put the criterea to begins with PB and
then you can see the rows with the patrnumbers started with PB that you can
copy them to where ever you want

Farhad Hodjat
 
Top