I wrote a macro that calls for input from the user. the macro aska series of
4 questions and then inserts them in the next available row. I need my macro
to look for the value input from the user on the first question. basically
the first question will ask what is your hfc number, i want the macro to then
search the sheet in column a for that value, if that val;ue is not in there
then it will proceed witht he rest,however if the macro finds that same
number then i want it to go to a serises of different questions to change the
information to th previous hfc. is there an "if" function of some nature to
do such a thing?