Forum Discussion
Solved
SORTING MULTIPLE WORKSHEETS IN A WORKBOOK
I play social darts and manage a spreadsheet to record members achievements each week, the wookbook contains a summary sheet and 48 weekly sheets. Each sheet contains members first and last names sto...
- If you make a little bit of changes, it might help. At first it will be tiring but going forward will be a huge time-cut.
I would suggest you place all the tables in 1 sheet and join them in to one formatted table. Probably males in one sheet and females in second sheet. You could place an empty column to separate each week. This would solve the 48 times you have re-enter their names and information. Sorting becomes easier since it is in-built in the formatted table. You could use a home sheet where you could put links to each week in the table for males and females. This will help get to the 48th week easily without having to scroll
Thankyou for the information, I understand the method for populating all the sheets and have successfully done that in the past, but then I can not sort all the sheets into alpha order. I am happy to provide an example but do not know how to add it to this reply.
If you make a little bit of changes, it might help. At first it will be tiring but going forward will be a huge time-cut.
I would suggest you place all the tables in 1 sheet and join them in to one formatted table. Probably males in one sheet and females in second sheet. You could place an empty column to separate each week. This would solve the 48 times you have re-enter their names and information. Sorting becomes easier since it is in-built in the formatted table. You could use a home sheet where you could put links to each week in the table for males and females. This will help get to the 48th week easily without having to scroll
I would suggest you place all the tables in 1 sheet and join them in to one formatted table. Probably males in one sheet and females in second sheet. You could place an empty column to separate each week. This would solve the 48 times you have re-enter their names and information. Sorting becomes easier since it is in-built in the formatted table. You could use a home sheet where you could put links to each week in the table for males and females. This will help get to the 48th week easily without having to scroll
- Thankyou I will give that a try
- Thanks whilst this has been a lot of work to set up the addition of new pers and sorting will be very easy, thanks for your help