Hello,

I have been getting my feet wet in Excel VBA Programming. I have run into a
problem. I am tring to have people run a report through a macro. The main
document is on Worksheet1 and I want a user to push a button to have another
worksheet appear and input the selected rows.

Example of Worksheet1 (Master Document):

A B C D
1 Mike 567 Basketball PG
2 Barry 999 Hockey C
3 Jim 123 Basketball SF
4 John 123 Basketball SF
5 Ken 999 Hockey C
6 Mark 123 Basketball PF
7 Don 123 Baseball SF
8 Lou 999 Golf C
9 Sam 123 Basketball PF

I want Worksheet2 to display a report in a specific order. The first order
is all people with basketball and 123. Then second which is Hockey with 999.
The Third is Golf.

Example of output Worksheet2 (Report):

A B C D
1 Jim 123 Basketball SF
2 John 123 Basketball SF
3 Mark 123 Basketball PF
4 Sam 123 Basketball PF
5
6 Barry 999 Hockey C
7 Ken 999 Hockey C
8
8 Lou 999 Golf C


Thanks for the help