Help Needed - Revised

  • Thread starter Thread starter RoadKing
  • Start date Start date
R

RoadKing

Good morning:
This is an example what I am trying to achieve
Col-A Col-C
Row 1: Name Address

Col-A Col-C
Row 4: Name Search Address Search

Note: The names & address will be hidden below the respective search Col's.

I need to search by name (R-4 / C-A) or by address (R-4 / C-C) and have the
corresponding name & address populate R-1 respectively AND THEN CLEAR THE
SEARCH CELLS LEAVING THE RESULTS IN R-1. Please keep in mind I am not a
programmer.

Thank you in advance
John
 
One way
Sub searchnameoradd()
ans = InputBox("enter name or address")
mr = Columns("o:p").Find(ans).Row
Range(Cells(mr, "o"), Cells(mr, "p")).Copy Range("q1")
End Sub
 
Back
Top