I read through all the posts, but couldn't find a solution that worked for
this.

I have a report that's pulled out of another system and converted into XL.
The column - A - "EMPLOYEE ID" is what I need to be able to sort on however
the report doesn't list it for every row associated with that employee, just
the first row that is associated. Is there a way by using macro or perhaps
vlookup or an if statement to automatically fill in the employee ID number
until it encounters the next non blank line?

The spreadsheet looks like:

A B C D
Employee ID Deduction Type Deduction Amount Total YTD
1001 BMH $12 $48
CDP $10 $50
ABC $100 $200
XYZ $5 $5
2001 BMH $12 $48
CDP $10 $50
ABC $100 $200
XYZ $5 $50
3001 BMH $12 $48
CDP $10 $50
ABC $100 $200
XYZ $5 $50

So ideally it would fill in 1001 in column A until it gets to 2001 and then
would fill in 2001 until it gets to 3001 and so on.

Thanks in advance for the assistance!!