Creating a script to insert data into excel spreadsheet

eeeevl

New Member
Joined
Feb 8, 2012
Messages
9
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
FlexibilityMuscular PowerMuscular PowerMuscular StrengthMuscular StrengthMuscular EnduranceAerobic EnduranceSpeedAgility
Sit&Reach (xx)cmStanding Long Jump (xxx)cmVertical Jump (xx)cmHand Drip Dynomometer (Grip Strength) (xx)kg30 Second Pushup Test (xx)60 Second Situp Test (xx)Multistage Fitness Test (beep test) (xx.x)50m Sprint (xx.x)secIllinois Agility Test (xx.x)sec
ScoreRatingScoreRatingScoreRatingScore
(Left)
Rating
(Left)
Score
(Left)
Rating
(Right)
ScoreRatingScoreRatingScoreRatingScoreRatingScoreRating
Poor Poor Poor Poor Poor Poor Poor Poor Excellent Excellent
Poor PoorPoor PoorPoor 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

NameFlexibilityNameMuscular PowerNameMuscular PowerNameMuscular StrengthNameMuscular Endurance
Sit&Reach (xx)cmStanding Long Jump (xxx)cmVertical Jump (xx)cm30 Second Pushup Test (xx)60 Second Situp Test (xx)
SamJones 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>
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top