I am an experienced MS Excel user and I am just now trying to learn
about using the functionality of macros. I am currently trying to
write a macro to do the following:

I have a spreadsheet that is set up in the following way:
The first row of data has an employee name in the futhest cell to the
left and then employee data, the second row has no employee name in the
first cell but there data related to that employee directly under the
data on the prior row. The third row is blank and the next row is
similar to row one and two except now employee name but it is still for
that employee, then another blank row. Once the next employees data
starts, the new employees name is printed in the cell once.

What I need is a macro to first delete all blank rows and , if
possible, a macro to copy the employee name down until the next
employee name appears. Once this is done I will then be able to sort
and run pivot table on the data.

Any help in writting the actual code would be GREATLY appreciated.

Thanks!
Gerald