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.

You say Sheet1!ColumnB matches Sheet2!ColumnC. Which other data columns are
populated on each of the sheets? Do you want to copy from Sheet2 to Sheet1 AND
from Sheet1 to Sheet2, or only in one direction?

You should be able to do this with VLOOKUP formulas on the destination sheet.
To simplify this, you should rearrange your columns: on Sheet1, move column B
into the left-most position. On Sheet2, do the same with column C, so you are
matching column A with column A.


On Sun, 4 Nov 2007 10:38:02 -0800, Waleed Mahmoud <Waleed
wrote:

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.