I have 2 sheets

First one has the source ISBN numbers for books. It is only 1 column say column A and say 40 rows

The second sheet is the destination sheet where macro supposed to look for the data located on A2 on the source file in the destination sheet.

Once it locates this value in the destination sheet it supposed to move 2 columns to the right and add "1" to the end of the text in this cell.

Since there are several rows(40) I guess it needs to be loop.

Please help

Thanks