VBA Code to select cells that have the word "Pediatrics" in it

[Esuric]

Hi guys,

I was hoping that you fine gentlepeople could help with a VBA code that selects values from cells that have the word "pediatrics" in it. For example, assume you have the following three cells in column A:

Family Oncology Group
Daily Pediatrics Clinic
Touch Pediatrics

I would like it if in column B it had:

-
Daily Pediatrics Clinic
Touch Pediatrics

So basically it would act like an if-statement that draws values with the phrase "pediatrics" in it. Hope my request is clear and thank you for your help in advance!

[mikeTRON]

Why not filter on column B for pediatrics?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[nickhunt]

John,
would it be possible to include an input box where the range to be searched and the word to search for could be input?

[JOHN H. DAVIS]

Yes, maybe?

Please Login or Register  to view this content.

[nickhunt]

Thank you John, that works for me.

[JOHN H. DAVIS]

You're welcome Nick, but in the future please comply with the Forum Rules and start a new thread. Review Rule No. 2 below.

http://www.excelforum.com/forum-rule...rum-rules.html