Refreshing Cells with RandBetween?

[koesherbacon]

Hello,

I'm a Dungeon Master for my Pathfinder RPG group and am making an Initiative/Combat Tracker in Excel 2013.

I'm not sure how to go about doing this. What I'd like to do is make a button that when pressed will refresh data stored in cells with the =RandBetween(1,20) function in order to calculate the initiative order.

Basically, when I click the button, it would automatically refresh the random integer in each cell that contains that function.

Is there a way to do this? If so, how complicated will it be? Will I have to be experienced with creating macros? I don't know the first thing about making macros...

Now that I think of it, that's actually the only function that would need to be refreshed, so if there's a way to just refresh the entire sheet with a click of the mouse, that would be fine too.

So, if anyone could give me some input, I would really appreciate it!

Thanks a lot!

 

[Jon von der Heyden]

RANDBETWEEN is a volatile worksheet function so each time you press F9​ (calculate); it should generate the next random number.

 

[koesherbacon]

Oh, I also just through of this as well. In Excel 2013, is there a button I could just add to my Ribbon which will do this? That would definitely be the simplest way to do it, but I'm not sure what that button would be called when adding it to my Ribbon.

Thanks a lot again!

 

[koesherbacon]

AWESOME!!! That helped me SOOOO much! I really, really, REALLY appreciate it, Jon!

 

[skf786]

i would like a random number between 1 and 180 in a cell that refreshes every 2 seconds. any way of doing that?