Hello. I have a sheet with certain used rows with gaps in between. I want a macro that goes through column L and if it finds a cell that is used copy that entire row and paste it on a sheet named Compiled data. I started with a macro but it only copies the first unused row. I want the macro to copy and paste all rows where Column L is not blank. Kindly help.