VBA Code to Find within a Sheet

[itsgrady]

A little new to VBA code but I am enjoying the process of learning the VBA.

I need some help to type a VBA Code to do the follow: I need to type the search criteria in a cell (O2) and then find xls.values in Column B. I also need to go to the cell (if possible, I would like to go 3 rows down and 3 columns over) where the criteria is found.

I also need to Find Next if more than one matched criteria.

criteria will be a Name. My sheet has 2,000 rows.

 

[itsgrady]

What are you going to do when you get to the offset cell?
Doing something manually?
or
Doing something that can be done by macro?

Something Manually.

 

[Akuini]

Something Manually.

Other members have offered you some solutions. Have you tried them?