I have two worksheets (i.e. abc & def ) in same workbook. Only one column
in the two workbooks (i.e column B in abc worksheet and column C in def
worksheet) containing common data. I want excel to compare each cell in
column B with each cell in column C and if it is identical, Excel should
copy all corresponding data in same raw and past them in the corresponding
raw inr the other sheet.