Drop down list in column based on fetched known data

[Jetpilot]

So I'm trying to look at the solutions of betting certain amounts on roulette

Rather than changing the amount in column B every time. I would like to compare betting methods quickly.
I would like a drop down box on b1 that I can select betting amounts that will auto fill the column b2 to b14.
Of course I will have the betting amounts on another sheet with a title that it can grab the data from.
Is this possible to do? ......basically fetch known data and fill out a column with a drop down box that has Titles of the betting styles?
Thanks for any help out there!

BET#	bet amount $	win @ BET# bankroll
1	1.0	102.0
2	1.0	101.0
3	2.0	102.0
4	3.0	102.0
5	5.0	103.0
6	8.0	104.0
7	13.0	106.0
8	21.0	109.0
9	33.0	112.0
10	20.0	53.0
11	20.0	33.0
12	32.0	37.0
13	32.0	5.0
14	32.0	-27.0

 

[scoudny]

Hi Jetpilot, are you talking about having a table with the bet amounts and using the dropdown in B1 to select the column for the bet amounts?
An easier option would be to have a helper column, for want of a better name, and just have calculations in B2-B14.