Im using excel to import a log file that keeps track some information about my printers on the network and appends it to the same excel sheet.

The Columns are:

Date
Device Model
Hardware Address
IP Address
Serial Number
Total Page Count
Total Clr Page Count

The location is identified by the IP address. I like to know how i can create a macro to search all the rows every time i import the log file and have a msgbox popup to warn that a printer changed location. (i.e IP Address changed)

Thanks in advance