Removing blank Rows and Organize Data...

[swade730]

Ok,

So My macro so far is built to find all the PGs (point guards) on Sheet1 and paste them on sheet2 (See module 1)

The problem:
When the PGs are pasted to sheet 2 -there are blank rows that appear which need to be deleted. Also, the players need to be ranked from the one with the highest points
(column B will reflect points),
all the way down to the player who scores the least points.

How would I achieve this in VBA?

Attached is my spreadsheet...

Thank You for checking out my post

[apo]

Hi..

Isn't this the same as your other Thread.. ? stnkynts and I both gave a working solution there..

http://www.excelforum.com/excel-prog...ml#post3487895

[swade730]

Thank You, I like how you consolidated that bossman