Auto copy down depending on criteria

[Guest]

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

 

[Debra Dalgleish]

There are instructions here for filling blank cells in a column:

http://www.contextures.com/xlDataEntry02.html

 

[Guest]

Thank you very much.
I have used the contextures site offen, and have never needed the data entry
section, until now. It's very useful

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know that it helped.