IF THEN GOTO urgent!!!

H

HJ

I need to set up a macro to refer 2 data in worksheet1 and
worksheet2 respectively, and judge if one is equal or less
than the other one, if yes, then assign a formula to a
cell in worksheet 1; if not, then go to read another data
in worksheet 2 from the following row.

Could you help me in the structure of IF, THEN and GOTO
command, and how to refer data in different worksheet and
different column? thank you very much, it's urgent!!
 
F

Frank Kabel

Hi
what formula do you want to use. That is: what are you trying to
achieve. Maybe a macro is not required for this but VLOOKUP could do?
 
Top