Ok here is my problem. I want a macro to copy rows from one sheet to another but I only want to copy the ones that have a value of 4 or more in column C. I can get them to copy over but I want the macro to also get rid of all of the blank lines in between the copied rows.

The values in column C change daily so I want to be able to run the macro each day to update the other sheet rather than having to copy and delete each time.