Finding Range of People names using Initials

Hi Guys,

I needed some assistance with searching for peoples names in my sheet.

I've got a cell which contains the initials of the person, i want to search for the Location of the cell that contains the name:

A5: JS [initials of person]

H2 I2 J2 K2 L2 M2
H2 - M2: JohnSmith | PeterJohnson | SamBrown | CamBlue | SteveRed | TonyGreen | [Names of people to look for from A5]


Notice there isnt any spaces between the names in the range to search.

I want the macro to return the Column and Row of the Name when found into cell A6.

e.g if A5 = CB
(Look for Name in Range H2 - M2)
Then A6 = K2

Thnx

Hello Jordan,

This macro uses the cell ranges in your example but you can easily change them if you need to for what you are actually using.

Please Login or Register  to view this content.

Hello Jordan,

Looks like you had no trouble adapting the code. Glad I could help.