Thread: Comparing Addresses from 2 different Worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AAH AAH is offline
external usenet poster
  
Posts: 6
Default Comparing Addresses from 2 different Worksheets
I am trying to compare addresses from two different worksheets in a WorkBook.
Worksht one D4:D7379 (Address line 1), E4:E7379 (Address line 2) and
Worksht two C4:C5431 (Address line 1), D4:D7379 (Address line 2). I want to
copy the cells that are not a match to be Highligted with RED.
--
AAH
Reply With QuoteReply With Quote