Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case for Sorting / Grouping Columns
Hello:
I have a worksheet that contains data in columns. Above the column headers I am adding three category rows. The categories are independent of each other--not subcats of the other two. I am placing labels in the row-cells that assign the category value to the column. My objective is to programmatically create views based on either of these 3 categories. Something like this: In this region (which is the entire worksheet), if Row 1 says X, y, z: hide these columns, hide rows 2 & 3 If Row 2 says x, y, z: unhide all, then hide these columns, hide rows 1 & 3 Etc. It seems this would be easy to do with a case select. I'm recording it manually in the meantime. This should be fun for anyone out there with the time~ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case for Sorting / Grouping Columns
did you get this figured out yet?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case for Sorting / Grouping Columns
Hi Chip: nope--haven't had any time to spend on it yet.
Also, to simplify and add clarity, this is what i will want to do: Based on the values in any of R1-3C[any], unhide all columns; if necessary hide rows 1-3; and hide column(s) a, b, c (or any of the gazillion columns). Footnote: if i can do this with Rows 1-3 hidden, that would be good. Otherwise will add in the code to unhide them at the beginning of the routine. I know it's a relatively simple thing to do....just am very rusty on non-recorded vba such as Case Selects. "Chip" wrote: did you get this figured out yet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on my Case of grouping the SW | Excel Worksheet Functions | |||
Select all columns with data for sorting. | Excel Discussion (Misc queries) | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Sorting multiple columns and maintaining grouping of information | Excel Discussion (Misc queries) | |||
Pivot tables and grouping words that are both upper and lower case | Excel Worksheet Functions |