IF THEN GOTO urgent!!!

  • Thread starter Thread starter HJ
  • Start date Start date
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!!
 
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?
 
Back
Top