View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCakes PCakes is offline
external usenet poster
 
Posts: 11
Default Cross Reference 2 columns in seperate workbooks

Hi, I am trying to determine if I can cross reference 2 columns in seperate
workbooks looking for duplicates. The workbooks are not identical.

Work book 1 would be column A
Worbook 2 would be column B

I would like to delete the rows in Workbook 2 if the data in the 2 columns
in both workbooks match.

Any ideas?

Pcakes