Search for variable and copy row

[tobeychris]

I've been searching for the answer to my question, but I can't seem to find it.

Firstly, I have three worksheets, the first (Master) is a master list of roll numbers, names and addresses. The second (Roll Numbers) is a list of roll numbers, and the third is where I want my output (Addresses).

What I want to do is select the first value from the list of roll numbers, find that value in the master sheet, then copy the master sheet's entire row and paste it into the addresses sheet in a row corresponding to the Roll Number's row.

What I have looks like this:

Please Login or Register  to view this content.

Roll number only has one column, A1 is a title, and the data starts from A2 to any length of roll numbers.

Master has 15 columns, and the roll numbers are located in K

Addresses will simply look like a shortened Master sheet.

This doesn't actually work, and only runs once (doesn't goto cell A3 and start the search again) If someone could help me it would be greatly appreciated.

[tobeychris]

I've attached a modified file with an example of what I'm requesting. The file also has a completed Addresses page with the end result that I am looking for. This page would normally only start with the headers.

[mrice]

Try this shortened macro

Please Login or Register  to view this content.

[tobeychris]

Works perfectly, but how do I now get it to do an entire list in the Roll Numbers sheet?

[VBA Noob]

One way using mrice code

Please Login or Register  to view this content.

HTH
VBA Noob

[tobeychris]

Thank you for the help, it works perfectly.