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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top