|Did you realize that your post was one long sentence? I was exhausted by the time I finished it! Feel free to throw a period in there every now and then. ;-)|
First, make a backup of your workbook in case things go terribly wrong.
Next, put the list of ID's the boss gave you in a different sheet - let's say Sheet2, Column A.
Now, let's assume the list you need delete rows from are in Sheet1, Column A.
Right-click the sheet tab for Sheet1 or Sheet2, choose View Code and paste this in. Run it and see what happens.
'Determine last row in big list
LastOrgRow = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
'Determine last row in Boss's List
LastBossRow = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row
'Loop through Boss's List
For ChkNxt = 1 To LastBossRow
'Grab next ID
ID = Sheets(2).Range("A" & ChkNxt)
'Look for ID on Sheet1
With Sheets(1).Range("A1:A" & LastOrgRow)
Set c = .Find(ID, lookat:=xlPart)
'If it's found, delete the row
If Not c Is Nothing Then c.EntireRow.Delete shift:=xlUp