Open Workbook and Search based on column values

Hi all,

I’m trying to have a macro run based on queried data (that is constantly changing) that opens another workbook and checks certain columns in the original workbook for those same fields in the new workbook.

So say for example the search path is “C:\myfolder\document.xls”. I need the macro to open document.xls and (from the original workbook) search the values from columns K, L, M, N and highlight those cells (in document.xls) that match in yellow and display a message when the macro is finished which cells it didn't find a match for.

the data in the table columns is constantly refreshed (say once a day) so it would need to include all rows in columns K,L,M,N.

i've done somewhat similar searches before although for folders that were just being copied and pasted to another folder. not sure where to start, thanks guys!

bump, anyone?