VBA to search list and apply value to different list

[KyleJackMorrison]

Hello, wonder if you can help me.

I have a list comprising of:

ID	Title	Name	Dept
2223344	Mr	Adam	1 Dept
3344555	Miss	Hannah	1 Dept
7755882	Mrs	Jade	2 Dept
9772348	Mr	Joe	3 Dept

<tbody>
</tbody>

The external program that i use exports a csv however leaves out the 'Dept'
Is there a way to run a vba from my list here to then enter it on the csv list:

ID	Title	Name
9772348	Mr	Joe
3344555	Miss	Hannah
7755882	Mrs	Jade
2223344	Mr	Adam

<tbody>
</tbody>

Note: My original list is sorted alphabetically. The csv is sorted by id number.

Many thanks in advance.