Hi
I would try to use Filter. Goto 'Data - filter - advanced filter'
have a look at
http://www.contextures.com/xladvfilter01.html
for using filters

Frank

Thank you,

I have a spreadsheet that uses web querry to download date into a
spreadsheet, however i need to be able to extract data from the cells
see below:-

Cell A Cell B Cell C
Shergar 97 ****
Flinstone 78 ***
Me Again 1000 ****

what I want to do is be able to search cell C for all the **** and
extract the horses name in cell A and save this info to another
sheet.
so in the above example I would have

Shergar ****
Me Again ****

Ps there could upto 500 horses to search each on its own line

how would i write a VB piece of code to do this ?

any help would be welcome

thanks
headbutt


---
Message posted from http://www.ExcelForum.com/