Auto List Randomizer

[j_christley]

Hi there,

I have a list of films I want to see, and I want to produce a random "Next film on the list" each day. Is that possible? My objective is to make the list appear fresh to my eyes to stave off the sensation of "option paralysis." Those among you who are movie fanatics may understand what I'm referring to.

In short, every calendar day I open the spreadsheet, the single column is in a completely new order. Or, if "daily" isn't an option, every time I open the sheet, or something else?

Thanks in advance!

p.s. I am aware of the =Rand() function and have toyed around with it for manual randomization.

[martindwilson]

rand() recalculates on workbook open

[j_christley]

But it doesn't execute a re-sort.

[shg]

Have you tried recording a macro?

[kalak]

Hi there,

I have a list of films I want to see, and I want to produce a random "Next film on the list" each day. Is that possible? My objective is to make the list appear fresh to my eyes to stave off the sensation of "option paralysis." Those among you who are movie fanatics may understand what I'm referring to.

In short, every calendar day I open the spreadsheet, the single column is in a completely new order. Or, if "daily" isn't an option, every time I open the sheet, or something else?

Thanks in advance!

p.s. I am aware of the =Rand() function and have toyed around with it for manual randomization.

Here's a file that you might like to have a look at.

Maybe of some help to you?

[Cofad]

Here's an idea that might work:

http://www.lifehacker.com.au/2012/03...omly-in-excel/