View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Comparing lists in 2 workbooks and copying missing rows into new W

Hi,

I have two workbooks that I need to compare and then copy the data that is
missing from the original workbook (but present in the second one) into a
third new workbook. To complicate matters for every comparison the filename
of the workbooks to be compared chages.

I only need to compare rows as any changes will be the insertion of a new
row somewhere within the file.

Any help with a VBA code / macro that could do this would be extreamly
helpful.

Thank you very much