add data with matching criteria

**tuneloon** · 10-16-2008, 12:35 PM

I am working with two worksheets

Stock -
Info -

I need to match the data in Info(Column4) with the data in Stock(Column1), and copy the corresponding data from Stock(Columns 2-27) on to the matching row of Info(Columns 12-37)

and do this until Stock(Column1) is blank

From previous help on this forum, I can do the loop til blank...

Please Login or Register  to view this content.

but I'm having trouble with the proper terminology for copying the matching data from one worksheet to the other.

Any help you can give me would be greatly appreciated

**Leith Ross** · 10-16-2008, 12:51 PM

Hello tuneloon,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross