Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
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) | |||
data entry on multiple worksheets | 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) |