How do I select all worksheets
Hi, I have a code that will filter a list and create a spreadsheet for each
value in a particular column. Eg. Student marks for subjects, user inputs data into sheet, and filters it by course. There are 3 courses, maths, english and science. If a student only does maths and science, it will only filter these two and create a maths and science worksheet with these values. How do I a) Select all the worksheets that exist (obviously this changes depending on how many sheets get generated by the filter) and b) Arrange the worksheet tab in a particular order (eg. maths, science, english - if a student only does maths and english, it will arrange it in maths then english as science worksheet does not exist). Can someone help me with this please? |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com