Macro to delete entire row on a condition

Hello,

I have data of the time in/time out of different individuals taken from another program . I don't know how to make a macro to delete entire row if that particular person timed in/timed out the second time. I'm new to macro and know only copy paste and offsets a little. I attached a sample file.

Thanks.

You can actually do this by hand pretty quickly using an a couple of formulas in empty columns and an AUTOFILTER. Look at Sheet2 and you'll see the formula, use the filter to filter for FALSE in the last column and you'll see the AutoFilter doing its job... you just delete all the rows left visible.

This macro actually uses the formulas as shown on sheet2. It inserts the formulas, applies the autofilter, deletes the visible rows, then removes the extra stuff again.

Please Login or Register  to view this content.