| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
| Sorting protected worksheets | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| How do I select all worksheets | Excel Worksheet Functions | |||
Linear Mode
