Organize Payroll

The Macro below takes out holes in a data set and organizes the data set by column 1. Pictured below is the before and after screen shots.

The macro has many different loops that it uses to step thru the data set. Each of the loops is documented in the code below.

Here is the macro. It may look unorganized in this view but copy and paste in a new module and walk thru it ......DON'T FORGET TO SAVE YOU WORK FIRST. MACROS CAN NOT BE UNDONE.