Compare two Sheets and copy value
 

I need to compare two lists and if there is a match then copy some cell
from one list to other otherwise do nothing. I need to put this in a
macro which is doing a whole bunch of other things.

So...I have sheet1 with column A,B,C,D,E,F,G,H Sheet2 with column
A,B,C,D,E,F,G,H. Now compare the values in each cell of column A in
sheet1 with value in each cell of column A in sheet2. If there is a
match, copy value from cell in same row and column H of sheet2 to same
row column H of sheet1... if no match then leave the original value in
sheet1.

Can it be done? I was trying
=IF(MATCH(A2,Dummy1!$A$2:$A$533,0)<"#N/A",VLOOKUP(A2,Dummy1!$A$2:$H$533,8,FALSE),I8)

but this doesn't give any promising results and I don't know how to
leave the original value that was there in original cell and this
wouldn't work in a macro.......I need to put something in a macro.

Thanks, Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=538417

Compare two Sheets and copy value
 

Perhaps a trip to vba help index for FINDNEXT will be of help?

--
Don Guillett
SalesAid Software

"sa02000" wrote in
message ...

I need to compare two lists and if there is a match then copy some cell
from one list to other otherwise do nothing. I need to put this in a
macro which is doing a whole bunch of other things.

So...I have sheet1 with column A,B,C,D,E,F,G,H Sheet2 with column
A,B,C,D,E,F,G,H. Now compare the values in each cell of column A in
sheet1 with value in each cell of column A in sheet2. If there is a
match, copy value from cell in same row and column H of sheet2 to same
row column H of sheet1... if no match then leave the original value in
sheet1.

Can it be done? I was trying
=IF(MATCH(A2,Dummy1!$A$2:$A$533,0)<"#N/A",VLOOKUP(A2,Dummy1!$A$2:$H$533,8,FALSE),I8)

but this doesn't give any promising results and I don't know how to
leave the original value that was there in original cell and this
wouldn't work in a macro.......I need to put something in a macro.

Thanks, Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile:
http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=538417