Hi The Internet!
Currently, I have a table with many different headers. The user selects an item in the first column at which time only 3-5 of the headers are useful depending on the selected item.
Simplified Ex:
<tbody>
</tbody>
Ideally, I would limit their visibility to just the needed headers. I have tried:
1)Creating a table with a new line of headers for each row and then pulling this in with a modified index/match function, however this introduces mass complexity as there are equations which reside in many columns which then must be listed as text and run through a VBA function to evaluate the text as a function which will become messy as soon as the text reference changes (i.e. the text formula lists E3 but then a new column is inserted and E3 becomes F3 but my text will still say E3. There is even more complexity there but needless to say it lacks efficiency.
2)A vba function that hides columns based on the selected row, however this clears the undo stack each time. If it was just me messing with the worksheet that may be acceptable, but it will be used by a team and they could easily make mistakes that they'll want to undo.
Is there a better option that I'm not considering?
Thanks!
Currently, I have a table with many different headers. The user selects an item in the first column at which time only 3-5 of the headers are useful depending on the selected item.
Simplified Ex:
Selection Interaction | Select Website | Header 2 |
Interaction - Open a Website | User Needs to Input Something Here | User doesn't care about this |
<tbody>
</tbody>
Ideally, I would limit their visibility to just the needed headers. I have tried:
1)Creating a table with a new line of headers for each row and then pulling this in with a modified index/match function, however this introduces mass complexity as there are equations which reside in many columns which then must be listed as text and run through a VBA function to evaluate the text as a function which will become messy as soon as the text reference changes (i.e. the text formula lists E3 but then a new column is inserted and E3 becomes F3 but my text will still say E3. There is even more complexity there but needless to say it lacks efficiency.
2)A vba function that hides columns based on the selected row, however this clears the undo stack each time. If it was just me messing with the worksheet that may be acceptable, but it will be used by a team and they could easily make mistakes that they'll want to undo.
Is there a better option that I'm not considering?
Thanks!
Last edited: