thankyou venkat for the reply.

sorry for the lack of information, but im a real newbie when it comes to this. Im just trying to help the girlfriend.
she needs to compare ID numbers with sheet 1 and sheet 2 both column D and get the missing data to a new sheet (all rows of missing data) sheet 1 will have the correct data, where sheet 2 is where we think there are missing ID's and perhaps some new ID's that are not in sheet 1. (new clients)

confusing I know.

screenshot below.

thanks again for your help and time.

\1