Need a macro to search for the data located in another sheet

[misterno]

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

 

[misterno]

Can someone help me please?

 

[misterno]

I can provide the files if needed

 

[Michael M]

Is this 2 workbooks or 2 workSHEETS ??

A2 on the source file in the destination sheet

 

[hiker95]

misterno,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

Is this 2 workbooks or 2 workSHEETS ??

3. Are we working in one workbook, with 2 worksheets?

4. Or, are we working in two different workbooks?


If we are working in 1 workbook, with 2 worksheets, then, to start off, and, so that we can get it right on the first try:

Can you post screenshots of the two actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[misterno]

Here is the source file

source File - Dosya Web

Here is the destination file

Destination File - Dosya Web


I use Excel 2007

I use Windows 7

This is 2 different files

 

[misterno]

I need help

Can someone please post a solution?

 

[hiker95]

misterno,

I have not worked with multiple workbooks in a very long time.

And, I do not want to down load anything from any service other than the site in my reply #5.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Michael M]

Ditto for me too !!
Why not copy the Sheet with the list of ISBN's into a fresh sheet in the Destination Workbook....then go from there