Hi all,

I have the following data on a worksheet. I need to create some way of
automatically copying the "Employee names" and the "Employed" down to the
next cells but not copy over the next employees name that appears in the list.

Each employees information has a cell at the bottom of the "Employed" column
that says "Total" at the end. The next employee will start after this cell.

I could do it manually but my worksheet is 45,000 rows.

Please help

Employee Name Employed Transaction Name

James Adams 07/10/03 Auto Ord Time
Sick No Cert.
Auto Ord Time
Sunday Loading






Employee Name Employed Transaction Name

A/L Variance
Sales Commiss
UsedSal Commiss

TOTAL

Aquiles Alvarez 27/03/06 Auto Ord Time
Manual Ord Time