Forum

Consolidating Excel...
 
Notifications
Clear all

Consolidating Excel Worksheets

2 Posts
2 Users
0 Reactions
159 Views
(@dalpura16)
Posts: 2
Active Member
Topic starter
 

Previously  set up a workbook with 94 worksheets each with 53 lines detailing the Roseworthy graduates and their year of graduation

Can I put all this information on one worksheet (and how)

I will then be able to sort by year of graduation as well as surname of the student

 

 
Posted : 10/09/2024 2:05 am
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Have a look at this blog post. It explains how to combine multiple worksheets in on eworkbook.

https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query

 
Posted : 10/09/2024 3:03 am
Share: