Help with code; write over if cells match

[danpo]

I have an excel code that exports a row of data to another workbook. The exported data is added in the end of the table. This is done with the following code:

Please Login or Register  to view this content.

I want add a feature that checks if the data in B42 (from the workbook i want to export from) matches a cell in row B in the workbook I want to export to. If this is done, I want it replace that row with the exported row, if not, I want it to use the original code and place it in the end.

/danpo

[Andrew-R]

OK, how about:

Please Login or Register  to view this content.