Hi
How to write this command in vba?:
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c1 in sheet2
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c2 in sheet2
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c3 in sheet2
...........................
...........................
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c(i) in sheet2
How to write this command in vba?:
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c1 in sheet2
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c2 in sheet2
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c3 in sheet2
...........................
...........................
If cell B1 in sheet1 was greater than 50, then cell A2 copy in c(i) in sheet2