Ok, this is what I'd like to do in Excel: I have a few columns of data
of different length, so it is not a complete database.
In the first column I have number of flowers, from 1 to
running down), second column: number of bunches from 1 to 5, third
column: number of tables from 1 to 30 and the 4th column: price from $1
I would like to create drop down boxes for each column independently of
each other so I can select various combinations of data and get a TOTAL
figure (which of course would be calculated automatically, as there are
too many permutations for me to calculate it manually.) The total would
be calculated by multiplying the various values selected in each
column, for example:
5 flowers x 3 bunches x 10 tables x $7 = $1050
How do I do that?
Second question which is related to
the previous (thought will write it all up in one post), I have seen it done, and used it, but didn’t create it so don't
really know how it was done. It's almost a copy of the previous results to create scenarios for a time period (rather than
seeing them one by one).
Also drop down boxes, for the same info (number of flowers, bunches,
tables and price), this time on the left hand side (I remember that the
input values for these drop down boxes were on a separate sheet, where
I could add for example more prices to the range). Going across - will
be for example months (Jan - Dec). And for each cell in the table, I
will see the income, for each month (depending what I have
selected on the left hand side).
But for comparison purposes, I would like to create a few scenarios,
and each would a different growth pattern. Say, first one, 20% month on
month, second - 15% etc.
I'm not sure if I explained it enough, but I hope someone would be
able to help me. And if you need more explanation, please let me
know. I'm attaching a small xls file with some data - hope this helps.
Thank you so much!!!