I need help with a macro I am going to build - not sure at all how to get
there.
I want to create a macro that when ran will pop up box with three entry
fields:
Name1:
Name2:
Account#:

when the user populates name 1 it will search column B; once a match is
found it will set focus to that found cell, then a vb yes/no window will pop
up. If the user answers yes then it will set focus to column b of that same
row and the macro will end otherwise if no is selected it will continue to
search the column and end the maco with a pop up no data found.

same thing with the other two choices except:
Name 2 will search column d and account# will search column f

I would appreciate any help you can provide