IF Sheet1 Cell A2 = value, THEN copy Sheet1 Row 2 to Sheet2 Row 2....?

Hi, I'm a fairly basic user and have been ragging my brain over this one: What is the syntax for the above? So much so that I've joined because of if (wont be suprised if I'm here more often).

Cheers.

IF Sheet1 Cell A2 = value,

you mean that sheet1 A2 is NOT blank.

then try this macro(modify to suit you)

Please Login or Register  to view this content.