How to compare 2 lists?

Hi. I have two lists in Column A and Column B. I would like to have a VBA script that picks out those entries found in A but not in B and returns these entries into column C. Thank you very much!

Hey Guys,

I need a bit of a modification to this code...

Column B: Project Leader List
Column C: Project Leader Directory
Column D: Project Leader Telephone No
Column E: Project Leader Informal Name

The first column (B) is an imported list, it contains names that may or may not match those found in the Directory (column C), if they are already present then I do not want them added, if they are not in that list the I need it to prompt to (a) Ask for the Phone No & (b) Ask for the Informal name, this should then populate the relevant cells in the appropriate ros (columns d & e).

Anyone?

Please Login or Register  to view this content.