hi tony,

thanx 4 ur responze.

I want to compare each value (in each cells) in column A of sheet1 to column
A of sheet2. Then, if the value of a specified cell is same, it will compare
the value in the row of the cell in sheet1 to the value in the row of the
cell in sheet2. I think its better if I put an example: ;

if Cells (Row3, Column A) in sheet 1 = Cells (Row 7, Column A) of sheet2 ;

Then it will take the other value in Row3 of Column B,Column C,Column D, ...
Column n of sheet 1 and compare it with the other value in Row7 of Column B,
Column C,Column D, ...Column n of sheet 2.

ive tried so many way, but it doesn't work..


tony h wrote:
Ok so you have data in an array. You need to put in a bit more effor
into explaining what is the problem you are trying to resolve.

Friendly comment,
cheer

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1