I have two sheet(s), the first is called Names and the second is called
Master

in the Names sheet, I have the following:

A B C D
1 Name Work# Code
2 Doe, Jane 17 2
3 Doe, John 56 4
4 Edwards, Jeff 40
5 Franklin, Bob 27 2
6 Garcia, Sam 5 5
7 Henry, Joseph 0 5
8 Ignacio, Juan 48
9 Jackson, Frank 12

This list is an ALL inclusive list that can vary from 100 - 200 names at any
given time
and we would maintain list. this is created from our Host systems.

What I want to do is the following:

from the Name sheet, I only want to copy those names that has a Code number
next it. So,
in essence, create the Master sheet so that the Master sheet should look
like the following:

A B C D
1 Name Work# Code
2 Doe, Jane 17 2
3 Doe, John 56 4
4 Franklin, Bob 27 2
5 Garcia, Sam 5 5
6 Henry, Joseph 0 5
7
8

What I have been doing is sorting the data by column C (Code) and then
copying it over to the
Master sheet every other day. I just wanted to see I could automate it a
little bit.

Any and all help is greatly appreciated.

Argus