Macro to search spreadsheet

yes, but wouldn't it be easier to use a formula?

I don't know really....I've never done anything with formulas....

---------- Post added at 03:10 PM ---------- Previous post was at 03:09 PM ----------

hold on....do you mean things like =sum blah blah blah?

hi David, please check attachment

Hi Guys,

Having a look at the spreadsheet attached, it's really good. Is there any way for it to check if a cell contains part of the text, rather than matching it exactly? At the moment, the formula is =IF(ISBLANK(D3),"",IF(COUNTIF($A$1:$A$24,D3)>0,"PROCESS","DO NOT PROCESS"))

That way, I'm hoping to rule out any user error, for example if someone can't spell the name correctly.

Finally, the last thing I'm going to do is add each school's individual customer number next to them - is there a way for the spreadsheet to show that as well? So for example, in field B1 it will have the customer number for the school in field A1....

Hope that's clear!

Thanks for all you guys help, so glad I stumbled across this forum.

David.

hi David, do you mean sort of this?

You're a genius, yes! That's exactly what I'm after.

Once I add the customer numbers, will there be a way of making that list of results display each cells relevant customer number? I've re-attached and added a couple of generic customer numbers.

please check attachment

Man....amazing. That's awesome

How many cells will that cover? I'm anticipating about 500 schools being on this list by the time I've finished.

Thanks again Watersev - Huge appreciation for you

it will cover 500 and over easily

Fantastic, thanks so much

Hi guys

Ok, I have all the data in there that I need. One last thing - when I search, the results don't clear if I do a new search. Any idea how to fix this?

For example, if you first search for Bishop and get the results, then search for Bruton, you can see below the result for Bruton that the previous numbers don't disappear...

Schools(1).xls

please check attachment

Watersev for President.

Thanks again :D