Rabarberbarbaar
New Member
- Joined
- Sep 27, 2015
- Messages
- 5
Hello everybody and thanks in advance for reading this,
I've been toying with an idea for a menu selector. My partner and I usually squabble about what to eat and we've decided to outsource it to a neutral party. We want to load up some excel sheets with dishes we both like, with the required ingredients listed behind them so it'll double as a shopping list generator, cause I think that's neat.
The meat of my problem is I don't know how to do two things:
1. I want to make use of a random number generator (RNG) that won't pick the same number (dish) twice, before it's ran through every number in it's pool.
2. I don't know how to make a cell read a third cell that's named by a second cell. So the RNG would be the second cell, containing a value, which I want the first cell to read as being the address of the third cell. Because the third cell, for instance M20, would be where the dish is listed. All dishes would be listed in the M column. The RNG would provide the number 20. And the first cell determines that the dish on M20 would be made on dayX in weekY.
I hope I've managed to make myself clear. I've run out of ideas on what to google for on this.
Again, thanks for reading!
I've been toying with an idea for a menu selector. My partner and I usually squabble about what to eat and we've decided to outsource it to a neutral party. We want to load up some excel sheets with dishes we both like, with the required ingredients listed behind them so it'll double as a shopping list generator, cause I think that's neat.
The meat of my problem is I don't know how to do two things:
1. I want to make use of a random number generator (RNG) that won't pick the same number (dish) twice, before it's ran through every number in it's pool.
2. I don't know how to make a cell read a third cell that's named by a second cell. So the RNG would be the second cell, containing a value, which I want the first cell to read as being the address of the third cell. Because the third cell, for instance M20, would be where the dish is listed. All dishes would be listed in the M column. The RNG would provide the number 20. And the first cell determines that the dish on M20 would be made on dayX in weekY.
I hope I've managed to make myself clear. I've run out of ideas on what to google for on this.
Again, thanks for reading!
