How do I auto transfer rows of data from multiple sheets into a different sheet

dpirovich

New Member
Joined
Mar 9, 2016
Messages
1
Hello all,

I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival scoring system. One way is to use excel to automatically sort through some of the data for me. The problem is Im not savvy enough to set this up and so some help would be great.


What I want to do:
Below is an example of how I would like to set out my worksheets. There will be approx 12 worksheets (one for each form) and they will be set up as seen below.

Worksheet 1 (form M1)

Discus Event

[Row 1] Student Name, Year, Form, Throw 1, Throw 2, Throw 3, Best Throw

[Row 2] e.g jonny 8 M1 14m 15m 16m 16m


Worksheet 2 (form G1)

Discus Event

[Row 1] Student Name, Year, Form, Throw 1, Throw 2, Throw 3, Best Throw

[Row 2] e.g Jacko 8 M1 13m 15m 18m 18m


Final Scores
Discus Event

[row 1] Student Name, Year, Form, Best Throw



As seen above the last worksheet will be for the final scores. Essentially what I need is a way to send each row of student data from EACH worksheet to the "Final Scores" worksheet AND once it is at the final worksheet for it to sort itself from largest throw to smallest throw.
The purpose of this is so that after all of the data is input int other spreadsheet, I can order the best throws from highest to lowest and use the top 10 throws in my PE scoring system.

I cannot lose track of which student has thrown what and so all the data must stay together.


Some help would be great.
cheers.

DP
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

bfreescott

Board Regular
Joined
Aug 6, 2015
Messages
108
DP,

I'm not sure I really understand why you have two different "forms" for the same Discus Event, but what you need as best I can tell is a table with an auto-filter on the header row.

Once you set up the table, you can simply use the autofilter to filter on the student name and sort on throws.

But what I suspect will be of more value to you is to insert a pivot table based on your table.

If it were me doing it, I wouldn't separate your data into different forms and sheets. Just put everything into one table and then create a pivot on that table. If you're new to creating pivot tables, just google it. There is plenty of info on the net about them. Or come back to this thread and I will help you.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,130,042
Messages
5,639,734
Members
417,108
Latest member
Thein Than

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top