edwardzbrown
New Member
- Joined
- Jun 12, 2017
- Messages
- 20
I have a beautiful looking layout that is user friendly. I have a "Heading" row that denotes a "Category" below it. I have several Categories. In each Category is a series of cells that are fill-able as an "Entry." Each Entry has it's own functions and so on. Each Entry uses the same "Template" that I have loaded onto another sheet labeled "templates" (approximately 7 rows each). On the Heading row for each Category, I have a Active X button that inserts the Entry Template rows into the Category for the user to create additional Entries. The user can create new Entry rows as needed. I want each Category to be collapsible by an Active X toggle, but their range fluctuates based on new entries. So a static range to collapse isn't useful.
My idea (which you can tell me if it's over complicated) is to create "Tags." For example In the blank row below the first heading I have "9991" in white so it's invisible. In the row just above the next Category Heading row I have "9992". In my collapsing toggle button for that category I use those Tags to define the range I want hidden. The new entries are inserted between the Tags and so my collapsing range function keeps intact no matter how many new Entries are inserted.
Is that possible? is there a better way to do this? I have most of this put together, but assigning a range of between Tags is the part I can't figure out.
My idea (which you can tell me if it's over complicated) is to create "Tags." For example In the blank row below the first heading I have "9991" in white so it's invisible. In the row just above the next Category Heading row I have "9992". In my collapsing toggle button for that category I use those Tags to define the range I want hidden. The new entries are inserted between the Tags and so my collapsing range function keeps intact no matter how many new Entries are inserted.
Is that possible? is there a better way to do this? I have most of this put together, but assigning a range of between Tags is the part I can't figure out.