Thread: [SOLVED] Compare two files with the same ID
View Single Post
  #1  
Old 07-09-2009, 11:15 PM
Shark Man Shark Man is offline
Registered User
  
Join Date: 15 Apr 2009
Location: Israel
MS Office Version:Excel 2003
Posts: 33
Shark Man is becoming part of the community
Compare two files with the same ID
Hello Experts
I have one xls sheet with employee’s information, at column A I have ID number -called Mater.
I have second xls sheet with update employee’s information, at column A i have the same ID number - called update file.

I need help with VBA code that update the Master file according to the update file (The ID at column A is the key between the files)and mark with color the update.

The file contain more the 20,000 records and with 10 columns

See example

Thanks Alot
Shark
Attached Files
File Type: xls macro.xls (15.0 KB, 5 views)
Last edited by Shark Man; 07-10-2009 at 11:18 PM.
Reply With Quote