VLookup question from the new guy

[DonJackson]

Hello all! I'm lost, and not that good at VB.
I have a tab (CARS) that looks something like

Car Class
1 1
8 2
9 1
6 3
2 1

Lets assume we're using A1 and B1 for this info.

On my new tab (WINNERS) I need to list the car numbers based on class.
So the first three cars in class 1 will look something like this.
I need to look down to B300 for any class #1 entrys.

Car Class
1 1
9 1
2 1

Then I'll move to class 2 etc....
Maybe I'm trying to make too much of this, or the vlookup isn't the way to go?
Any help would be much appreciated.
Don

 

[DonJackson]

Hey guys, I'm almost there.
One new problem. I'm looking for the last cell that has data in it. I'm using the following:
finalrow = AddressSheet.Cells(301, 9).End(xlUp).Row

This finds my formula in the cells down to 310. I need only cells that has had the data copied over. The finalrow result is always 301, even though my data ends much above that.
Any thoughts?
Thanks again.
Don

 

[Michael M]

Try something like

finalrow=worksheets."Sheetname".cells(rows.count, "I").end(xlup).row