Does anyone know how to automatically copy cell above the current cell?
I have a long list of employees with account numbers.  However, I want
to only include employees with 6-xxxxx account numbers.  Having blank
cells on some of rows with account numbers, I may pull 6-xxxxx account
numbers without names after sorting the cells by account numbers.

Here is how my spreadsheet looks like:

ABDULLAH,MALIK    6-63027-1200
ABROKWA,JOE    2-11932-1100
                   2-11932-2000
                   2-11987-1010
                   2-11987-2000
ACTON,LATOYA    6-63027-1200
ACTON,LYNETTE    2-24001-1400
                   6-63027-1200

You see Lynette Acton has 2-xxxxx and 6-xxxxx account numbers.  I want
to pull only the 6-xxxxx account number.

Thanks so much!