Automatically copy cell above

E

Ellis

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!
 
Top