How can I automatically take data from one worksheet to another?

Hi there!

I need to track attendance hours for students who are in multiple courses.

The hours are all entered into one big summative sheet. Rows are labeled with student names.

Each student has two classes: one morning, one afternoon.

I would like to create worksheets for each class as well, so that I can add up weekly attendance specific to each class. There are six total classes.

How do I automatically take the hours from the summative worksheet to the class worksheet? I would like the class worksheets to automatically update when I enter the hours into the summative sheet.

I am a beginner at Excel, but I learn quickly

Thanks for your quick response excel_bat!

The tricky part is that I was given a summative sheet and I need to more or less keep it the same. I could add columns for class names but the hours are arranged like this:

attendance image.png

(Where there is a column to the left with student names.)

So the hours are not arranged by class, only date and AM/PM.

If I could (sorry, my Excel lingo is no good) transpose the entire table to a new worksheet, where it would automatically update as I enter info into the summative, and if I could delete the irrelevant columns and rows, I think that would solve my problem.

Thanks for your help! My predecessor at my new job forgot to train me on this.

Ok I scrubbed the names.

Attachment 433525

As you can see, I had great plans for the color schemes in my class sheets On "Sheet 17" I started by linking to the whole table and then deleting irrelevant columns and rows. I still have to figure out how to hide the empty ones, and I'll need to insert a few columns because I want to total by week. BUT if this Pivot Table thing will make my life easier, sweet.

2015 TEMP FALL II ATTENDANCE SHEET name scrub.xlsx

Does this work?

I have since figured out a rather long way to do it, so my task is done... but if you have an easier solution I'd love to hear it!

Wow, thanks so much excel_bat! So, if each student has a morning class and an afternoon class, and I want the summative to total ALL hours, and a sub page to total only their morning hours, is there an easy way to do that without having two rows for each student? I did figure out how to pull info by copy > paste link of the entire table, and then deleting rows for students not in the class and columns for afternoon hours. I'm then inserting columns to tally up weekly attendance for each class, which I have to enter into another database. Can I use pivot tables to do that without adding a second row for each student?

Dianalou... have you ever considered writing a Macro? I don't think it would be very difficult to do what you seem to describe and Excel's embedded VBA programming capabilities (Hit Alt + F11 on a macro-enabled Workbook) are powerful and easy to follow! Macros can be huge time-savers!

They can be used to create new Worksheets OR Workbooks. I take about 2,000 lines of info. from one worksheet and dump it all into another concise format in another workbook (that I choose to open automatically and execute in seconds with the push of a Macro button).