I am wanting to create a spreadsheet that automatically inserts data from one (workbook) sheet into another template. This template would need to have the data from the table below (Fitness Testing) inserted and sorted into the next table which ranks in order of score (highest to lowest) (Survival of the Fittest)... Hope that makes sense...
Fitness Testing
<colgroup><col span="2"><col span="2"><col span="6"><col><col span="3"><col span="2"><col span="4"></colgroup><tbody>
</tbody>
Survival of the Fittest
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Fitness Testing
Flexibility | Muscular Power | Muscular Power | Muscular Strength | Muscular Strength | Muscular Endurance | Aerobic Endurance | Speed | Agility | |||||||||||
Sit&Reach (xx)cm | Standing Long Jump (xxx)cm | Vertical Jump (xx)cm | Hand Drip Dynomometer (Grip Strength) (xx)kg | 30 Second Pushup Test (xx) | 60 Second Situp Test (xx) | Multistage Fitness Test (beep test) (xx.x) | 50m Sprint (xx.x)sec | Illinois Agility Test (xx.x)sec | |||||||||||
Score | Rating | Score | Rating | Score | Rating | Score (Left) | Rating (Left) | Score (Left) | Rating (Right) | Score | Rating | Score | Rating | Score | Rating | Score | Rating | Score | Rating |
Poor | Poor | Poor | Poor | Poor | Poor | Poor | Poor | Excellent | Excellent | ||||||||||
Poor | Poor | Poor | Poor | Poor | Poor | Poor | Poor | Excellent | Excellent | ||||||||||
Poor | Poor | Poor | Poor | Poor | Poor | Poor | Poor | Excellent | Excellent | ||||||||||
<colgroup><col span="2"><col span="2"><col span="6"><col><col span="3"><col span="2"><col span="4"></colgroup><tbody>
</tbody>
Survival of the Fittest
Name | Flexibility | Name | Muscular Power | Name | Muscular Power | Name | Muscular Strength | Name | Muscular Endurance | ||||||||||||||
Sit&Reach (xx)cm | Standing Long Jump (xxx)cm | Vertical Jump (xx)cm | 30 Second Pushup Test (xx) | 60 Second Situp Test (xx) | |||||||||||||||||||
Sam | Jones | 21 | |||||||||||||||||||||
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>