Auto copy down depending on criteria
 

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

Auto copy down depending on criteria
 

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

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

Kim wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Auto copy down depending on criteria
 

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

"Kim" wrote:

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

Auto copy down depending on criteria
 

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

Kimbo wrote:
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

"Kim" wrote:


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
Contextures
http://www.contextures.com/tiptech.html