View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sharmashanu sharmashanu is offline
external usenet poster
 
Posts: 28
Default macro for same value in 2 different sheets

Hii all
I am trying to write a macro to compare first 50 values of, say column
A of sheet 1 and column B of sheet 2. I want the macro to highlight
only those cells of column A that equal to sheet 2 column B values.
thanks