Good moring all,

I am still learning how to use the"IF THEN" function, could some please help.

How should I do this:

Example -

if cell A1 is = 1 I need to have column B2 to copy to another worksheet "sheet 2" in cell # B5. I only need it to save the results not the formulas. There are formulas in column B2. Can someone please help?

Thanks,
ALP