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

misterno

Board Regular
Joined
Mar 16, 2009
Messages
78
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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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.
 
Last edited:
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top