Notifications
Clear all
Dashboards & Charts
3
Posts
2
Users
0
Reactions
127
Views
Topic starter
If I have 1000 rows, I can sort I to low, medium, high. Is it possible to create a combo box to ask a question for each row - which won't be sequential as it's sorted. Is there a dynamic way to ensure the combo box is provided for the right cell if sorted ?
Posted : 25/11/2019 4:38 pm
Hi Mike,
Yikes, that sounds messy. Not that I can think of. You'd maybe have to write some VBA to do the sorting of the combo boxes because these are objects that float above the grid.
Mynda
Posted : 25/11/2019 7:00 pm
Topic starter
Yeah thats what I thought - sadly VBA, MACRO, etc all blocked for security.....so formula is the only way I can think of. I can get a cell address easy enough, but then I need to put the answer from the combo box to that address....
Posted : 25/11/2019 10:06 pm
