I have a column of data that I am sorting via a list of =rand() outputs in order to create a randomized list. I have created a macro of sort>expand, and it works correctly. I also have a script that detects a change in a cell, and if there is a change to run the macro. Yup, that works as well.
I would like the list to update with any data change on the page, so I placed '=randbetween(1,999)' in the referenced cell, trying to get the list to reorder itself any time a value on the page is changed.
The list will only update if I put the cursor into the cell containing =randbetween and strike 'return'.
How do I get the list to update any and every time the ran cell is updated?
Sample file: [url]http://www.6t2.net/9/[/URL]
Enter a character anywhere on the page, and the 'RNG Key' updates, along with column A. Enter a static # and the list updates.
Thanks in advance!
I would like the list to update with any data change on the page, so I placed '=randbetween(1,999)' in the referenced cell, trying to get the list to reorder itself any time a value on the page is changed.
The list will only update if I put the cursor into the cell containing =randbetween and strike 'return'.
How do I get the list to update any and every time the ran cell is updated?
Sample file: [url]http://www.6t2.net/9/[/URL]
Enter a character anywhere on the page, and the 'RNG Key' updates, along with column A. Enter a static # and the list updates.
Thanks in advance!
Last edited:
