Dulanic,

Sheet4 is the original source data Jerry created the macro for. Sheet1 is the full data minus the blanks, so is the proper location for the macro to run.