How to Update an Excel Class Schedule from a Class List
Question details
The user wants to automatically or manually update an Excel Class Schedule using data from a separate Class List workbook, and needs to know how to sort the list chronologically by day.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Managing a class timetable across different worksheets or workbooks and trying to sync or organize the data.
- Observed behavior
- Classes added to the Class List do not automatically appear in the separate Class Schedule workbook or worksheet.
Ensure that both your Class List and Class Schedule worksheets are open. Check if the two sheets are linked by existing formulas; if they are completely separate workbooks without connections, data will not synchronize automatically.
Sort the Class List by Day of the Week
Use the Custom Sort feature to organize your original class list chronologically by weekday, which acts as an immediate schedule without needing a separate sheet.
If you do not want to deal with complex formulas to link different workbooks, simply sorting your existing Class List by the days of the week is the most efficient way to view your schedule.
Highlight the entire table or data range containing your Class List.
Navigate to the 'Data' tab on the top ribbon and click on the 'Sort' icon.
From the sort dialog box, ensure you are sorting by the column that contains the days of the week.
Under the 'Order' dropdown option, select 'Custom List'. Choose the standard days of the week list (e.g., Monday, Tuesday, Wednesday) and click 'OK' to apply the chronological sort.

Manually Transfer Data to the Schedule Sheet
Since separate workbooks do not auto-populate without formulas, manually copying the data is a straightforward alternative.
Organize Your Class Schedule Effortlessly with WPS Office
WPS Spreadsheet provides powerful sorting, filtering, and cross-sheet referencing tools to help you manage your class schedules without the hassle. It is completely free and seamlessly handles your existing Excel files.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your class list workbook.
- 2. Select Your Data: Highlight the columns and rows containing your class information and scheduled days.
- 3. Apply Custom Sort: Go to the Data tab, click Sort, and choose Custom List to automatically organize your classes by the days of the week.

Frequently Asked Questions
Why doesn't my Class Schedule update automatically when I type in the Class List?
If the Class List and Class Schedule are in separate workbooks or worksheets without linked formulas, the data will not synchronize. You must either set up referencing formulas (like VLOOKUP or XLOOKUP) or manually copy the data over.
Can I link a separate Class List workbook to my Schedule?
Yes. You can use linking formulas by typing '=' in the Schedule cell and then clicking the corresponding cell in the Class List workbook. Keep in mind both workbooks may need to be accessible for the links to update reliably.
How do I sort my Excel schedule chronologically instead of alphabetically?
Instead of a standard A-Z sort, use the 'Custom Sort' feature in the Data tab. Select the column containing the days, and choose the 'Custom List' order (Monday, Tuesday, etc.) so the spreadsheet knows to sort by weekday sequence.




