add data with matching criteria

[tuneloon]

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...

itemInfo = 4 'Info Item # Column
itemStock = 1 'Stock Item # Column
currentRow = 1 'Start Row
done = False
Do
    'If the data in column itemStock is blank, then stop
    If Cells(currentRow, itemStock) = "" Then
        done = True
    Else
        currentRow = currentRow + 1
    End If
Loop Until done

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]

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] at the start of the line, and the tag [/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