Need help to find record

[ashgaroth]

I have a rather large Excel spreadsheet that I use for mail merges, etc.,

I also use it to get information from individual records for forms, letters, et al.

I would like to be able go straight to a record(row) without having to read through all the records before it (In RPG you use logical files that sit over a database and only use the records that match the logical file). Is there anything similar in VBA that I can use. For example: if I have a client with a surname of Smith and search by surname, I don't want to pick up Smithers or Smithson - or indeed any other surname. Likewise, each of my clients has a unique identifier (if I use this, I want to go straight to their record and not have to read all of the records prior to theirs). Any ideas peeps?

 

[Akuini]

Without VBA, you can use Find feature:
- Highlight a column
- Ctrl+F
- Check 'Match entire cell content'
- Type the keyword
- Cilck 'Find Next' or 'Find All'

 

[ashgaroth]

Without VBA, you can use Find feature:
- Highlight a column
- Ctrl+F
- Check 'Match entire cell content'
- Type the keyword
- Cilck 'Find Next' or 'Find All'

And how does this help me?

What is the point of answering "Without using VBA", when my query specifically asked for a VBA solution?

How do you propose that I use your 'solution' for mail merge?

Answers regarding VBA only please!!