Hello Excel Forum,

I have been struggling with a way to use an IF statement that determines if a cell in column B = 1 then copy that cell and the two cells next to it to a cell starting in range B50. Once the condition is true would want it to copy another below and so on.


B C D E D

1 E10 Rear door failed BL OK

2 B4 Clearance light inop. KL OK

2 C1 Fire extinguisher date expired KL Ok

1 E1 Bumper falling off BL NO




The first and fourth row have a "1" in column B. So as a result these two rows meet the condition and want to copy just the cell in B thru D. Results would look like below

First entry copied to cell B50

1 E10 Rear door failed
1 E1 Bumper falling off



Any help would be appreciated