I have a sheet similar to the following. Each section changes in length daily, so I need to be able to have my macro read this dynamically.
Name Rank
John Smith First
Angela Simms First
Mike Dunn First
Paul Nabors First
Tim Evans Second
Frank White Second
Gina Crow Second
Laura Wild Third
George Amos Third
Amy Jackson Third
James Shelton Third
I have up to 12 rankings, and each one can contain any number of entries daily. I'd like the macro to output something like:
First
John Smith
Angela Simms
Mike Dunn
Paul Nabors
Second
Tim Evans
Frank White
Gina Crow
Third
Laura Wild
George Amos
Amy Jackson
James Shelton
I should note that there are other columns of data to be transferred with each person. I can move the Rank column to column A if need be.
Name Rank
John Smith First
Angela Simms First
Mike Dunn First
Paul Nabors First
Tim Evans Second
Frank White Second
Gina Crow Second
Laura Wild Third
George Amos Third
Amy Jackson Third
James Shelton Third
I have up to 12 rankings, and each one can contain any number of entries daily. I'd like the macro to output something like:
First
John Smith
Angela Simms
Mike Dunn
Paul Nabors
Second
Tim Evans
Frank White
Gina Crow
Third
Laura Wild
George Amos
Amy Jackson
James Shelton
I should note that there are other columns of data to be transferred with each person. I can move the Rank column to column A if need be.