View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
u473 u473 is offline
external usenet poster
 
Posts: 184
Default Excel VBA. Compare 2 worksheets.

Ok, it works fine, thank you. I was worried with that long formula. I
am impressed.
Of Course, in my Workbook C, before entering your formula, I had
entered all new Employees and Projects.
In actual practice, how would I filter all new Employees in Col. A
and new Projects in Row 1 in Workbook B to update Workbook A before I
read the resulting exceptions in Workbook C.
Thank you again,

J.P.