Bless you Jim, I really appreciate this! :-) Let me play around with this for a while and report back ASAP!
--Dwayne On Mon, May 21, 2012 at 4:46 PM, Jim Plante <[email protected]> wrote: > Under Data->Validity... > Select "Cell Range" > That cell range should be your big-ass scenario set out on another sheet. > > Example: > Your scenario is on sheet "weights." > On the sheet that makes reference to this, select the cell that displays > the weight, and choose Data->Validity...; select "Cell Range" from the > dropdown box. Enter "weights.A1:weights.c80". > When you select the primary cell, a dropdown will appear showing all 80 > selections; scroll down and pick one. > > This is still too much of a PITA for regular use, but you asked. > > Let's simplify a little. Suppose your desired entry is like so: > We'll call this the Primary sheet, and name it "Prime". > A B C > 1 English USD 0,5kg > 2 > 3 > > On another sheet named "Criteria" have something like this > A > 1 English > 2 Norwegian > 3 Portuguese > ... > 15 USD > 16 GBP > 17 ESC > .... > 30 0.5kg > 31 1kg > 32 1.5kg > 33 2.0kg (personally, I'd leave off the "kg" in this table.k) > .... > 88 DHL > 89 FEX > 90 UPS > > Select cell Prime.A1. Select Data->Validity... > In the dialog, instead of "All values" you'll use the dropdown to select > "Cell Range." > Either enter the range in the entry box, or hit the little minimizer > button at the side and select the "Criteria" sheet; select cells a1:a3 for > the language. > > Move to B1 on the Primary sheet, select Data->Validity... and do it again. > This time, select A15:A17 > And so on. > > After these cells are filled, your sheet can do a lookup of prices or use > an external web-query import if your shipper provides a price sheet based > on weights. > > Regards, > Jim > > > > > > On May 21, 2012, at 7:00 AM, Tony wrote: > > > At budsjettmodell.xls <http://home.no/dwaynie/budsjettmodell.xls> > (courtesy > > of Innovation Norway <http://innovasjonnorge.no/>) - say for the sheet > > "Fast" - what sort of dropdowns are they using? > > > > Can't I just use those types of dropdowns inside a scenario? Or those > types > > of dropdowns without a scenario at all? > > > > I'm desperately trying to avoid having one big ass scenario containing: > > > > English - USD - 0,5kg > > English - USD - 1kg > > English - USD - 1,5kg > > English - USD - 2kg > > English - USD - 2,5kg > > English - USD - 3kg > > English - USD - 3,5kg > > English - USD - 4kg > > English - USD - 4,5kg > > English - USD - 5kg > > English - USD - 5,5kg > > English - USD - 6kg > > English - USD - 6,5kg > > English - USD - 7kg > > English - USD - 7,5kg > > English - USD - 8kg > > English - USD - 8,5kg > > English - USD - 9kg > > English - USD - 9,5kg > > English - USD - 10kg > > English - USD - 10,5kg > > English - USD - 11kg > > English - USD - 11,5kg > > English - USD - 12kg > > English - USD - 12,5kg > > English - USD - 13kg > > English - USD - 13,5kg > > English - USD - 14kg > > English - USD - 14,5kg > > English - USD - 15kg > > English - EUR - 0,5kg > > English - EUR - 1kg > > English - EUR - 1,5kg > > English - EUR - 2kg > > English - EUR - 2,5kg > > English - EUR - 3kg > > English - EUR - 3,5kg > > English - EUR - 4kg > > English - EUR - 4,5kg > > English - EUR - 5kg > > English - EUR - 5,5kg > > English - EUR - 6kg > > English - EUR - 6,5kg > > English - EUR - 7kg > > English - EUR - 7,5kg > > English - EUR - 8kg > > English - EUR - 8,5kg > > English - EUR - 9kg > > English - EUR - 9,5kg > > English - EUR - 10kg > > English - EUR - 10,5kg > > English - EUR - 11kg > > English - EUR - 11,5kg > > English - EUR - 12kg > > English - EUR - 12,5kg > > English - EUR - 13kg > > English - EUR - 13,5kg > > English - EUR - 14kg > > English - EUR - 14,5kg > > English - EUR - 15kg > > English - GBP - 0,5kg > > English - GBP - 1kg > > English - GBP - 1,5kg > > English - GBP - 2kg > > English - GBP - 2,5kg > > English - GBP - 3kg > > English - GBP - 3,5kg > > English - GBP - 4kg > > English - GBP - 4,5kg > > English - GBP - 5kg > > English - GBP - 5,5kg > > English - GBP - 6kg > > English - GBP - 6,5kg > > English - GBP - 7kg > > English - GBP - 7,5kg > > English - GBP - 8kg > > English - GBP - 8,5kg > > English - GBP - 9kg > > English - GBP - 9,5kg > > English - GBP - 10kg > > English - GBP - 10,5kg > > English - GBP - 11kg > > English - GBP - 11,5kg > > English - GBP - 12kg > > English - GBP - 12,5kg > > English - GBP - 13kg > > English - GBP - 13,5kg > > English - GBP - 14kg > > English - GBP - 14,5kg > > English - GBP - 15kg > > English - USD - 0,5 pounds > > English - USD - 1 pounds > > English - USD - 1,5 pounds > > English - USD - 2 pounds > > English - USD - 2,5 pounds > > English - USD - 3 pounds > > English - USD - 3,5 pounds > > English - USD - 4 pounds > > English - USD - 4,5 pounds > > English - USD - 5 pounds > > English - USD - 5,5 pounds > > English - USD - 6 pounds > > English - USD - 6,5 pounds > > English - USD - 7 pounds > > English - USD - 7,5 pounds > > English - USD - 8 pounds > > English - USD - 8,5 pounds > > English - USD - 9 pounds > > English - USD - 9,5 pounds > > English - USD - 10 pounds > > English - USD - 10,5 pounds > > English - USD - 11 pounds > > English - USD - 11,5 pounds > > English - USD - 12 pounds > > English - USD - 12,5 pounds > > English - USD - 13 pounds > > English - USD - 13,5 pounds > > English - USD - 14 pounds > > English - USD - 14,5 pounds > > English - USD - 15 pounds > > English - EUR - 0,5 pounds > > English - EUR - 1 pounds > > English - EUR - 1,5 pounds > > English - EUR - 2 pounds > > English - EUR - 2,5 pounds > > English - EUR - 3 pounds > > English - EUR - 3,5 pounds > > English - EUR - 4 pounds > > English - EUR - 4,5 pounds > > English - EUR - 5 pounds > > English - EUR - 5,5 pounds > > English - EUR - 6 pounds > > English - EUR - 6,5 pounds > > English - EUR - 7 pounds > > English - EUR - 7,5 pounds > > English - EUR - 8 pounds > > English - EUR - 8,5 pounds > > English - EUR - 9 pounds > > English - EUR - 9,5 pounds > > English - EUR - 10 pounds > > English - EUR - 10,5 pounds > > English - EUR - 11 pounds > > English - EUR - 11,5 pounds > > English - EUR - 12 pounds > > English - EUR - 12,5 pounds > > English - EUR - 13 pounds > > English - EUR - 13,5 pounds > > English - EUR - 14 pounds > > English - EUR - 14,5 pounds > > English - EUR - 15 pounds > > English - GBP - 0,5 pounds > > English - GBP - 1 pounds > > English - GBP - 1,5 pounds > > English - GBP - 2 pounds > > English - GBP - 2,5 pounds > > English - GBP - 3 pounds > > English - GBP - 3,5 pounds > > English - GBP - 4 pounds > > English - GBP - 4,5 pounds > > English - GBP - 5 pounds > > English - GBP - 5,5 pounds > > English - GBP - 6 pounds > > English - GBP - 6,5 pounds > > English - GBP - 7 pounds > > English - GBP - 7,5 pounds > > English - GBP - 8 pounds > > English - GBP - 8,5 pounds > > English - GBP - 9 pounds > > English - GBP - 9,5 pounds > > English - GBP - 10 pounds > > English - GBP - 10,5 pounds > > English - GBP - 11 pounds > > English - GBP - 11,5 pounds > > English - GBP - 12 pounds > > English - GBP - 12,5 pounds > > English - GBP - 13 pounds > > English - GBP - 13,5 pounds > > English - GBP - 14 pounds > > English - GBP - 14,5 pounds > > English - GBP - 15 pounds > > Norwegian - USD - 0,5kg > > Norwegian - USD - 1kg > > Norwegian - USD - 1,5kg > > Norwegian - USD - 2kg > > Norwegian - USD - 2,5kg > > Norwegian - USD - 3kg > > Norwegian - USD - 3,5kg > > Norwegian - USD - 4kg > > Norwegian - USD - 4,5kg > > Norwegian - USD - 5kg > > Norwegian - USD - 5,5kg > > Norwegian - USD - 6kg > > Norwegian - USD - 6,5kg > > Norwegian - USD - 7kg > > Norwegian - USD - 7,5kg > > Norwegian - USD - 8kg > > Norwegian - USD - 8,5kg > > Norwegian - USD - 9kg > > Norwegian - USD - 9,5kg > > Norwegian - USD - 10kg > > Norwegian - USD - 10,5kg > > Norwegian - USD - 11kg > > Norwegian - USD - 11,5kg > > Norwegian - USD - 12kg > > Norwegian - USD - 12,5kg > > Norwegian - USD - 13kg > > Norwegian - USD - 13,5kg > > Norwegian - USD - 14kg > > Norwegian - USD - 14,5kg > > Norwegian - USD - 15kg > > Norwegian - EUR - 0,5kg > > Norwegian - EUR - 1kg > > Norwegian - EUR - 1,5kg > > Norwegian - EUR - 2kg > > Norwegian - EUR - 2,5kg > > Norwegian - EUR - 3kg > > Norwegian - EUR - 3,5kg > > Norwegian - EUR - 4kg > > Norwegian - EUR - 4,5kg > > Norwegian - EUR - 5kg > > Norwegian - EUR - 5,5kg > > Norwegian - EUR - 6kg > > Norwegian - EUR - 6,5kg > > Norwegian - EUR - 7kg > > Norwegian - EUR - 7,5kg > > Norwegian - EUR - 8kg > > Norwegian - EUR - 8,5kg > > Norwegian - EUR - 9kg > > Norwegian - EUR - 9,5kg > > Norwegian - EUR - 10kg > > Norwegian - EUR - 10,5kg > > Norwegian - EUR - 11kg > > Norwegian - EUR - 11,5kg > > Norwegian - EUR - 12kg > > Norwegian - EUR - 12,5kg > > Norwegian - EUR - 13kg > > Norwegian - EUR - 13,5kg > > Norwegian - EUR - 14kg > > Norwegian - EUR - 14,5kg > > Norwegian - EUR - 15kg > > Norwegian - GBP - 0,5kg > > Norwegian - GBP - 1kg > > Norwegian - GBP - 1,5kg > > Norwegian - GBP - 2kg > > Norwegian - GBP - 2,5kg > > Norwegian - GBP - 3kg > > Norwegian - GBP - 3,5kg > > Norwegian - GBP - 4kg > > Norwegian - GBP - 4,5kg > > Norwegian - GBP - 5kg > > Norwegian - GBP - 5,5kg > > Norwegian - GBP - 6kg > > Norwegian - GBP - 6,5kg > > Norwegian - GBP - 7kg > > Norwegian - GBP - 7,5kg > > Norwegian - GBP - 8kg > > Norwegian - GBP - 8,5kg > > Norwegian - GBP - 9kg > > Norwegian - GBP - 9,5kg > > Norwegian - GBP - 10kg > > Norwegian - GBP - 10,5kg > > Norwegian - GBP - 11kg > > Norwegian - GBP - 11,5kg > > Norwegian - GBP - 12kg > > Norwegian - GBP - 12,5kg > > Norwegian - GBP - 13kg > > Norwegian - GBP - 13,5kg > > Norwegian - GBP - 14kg > > Norwegian - GBP - 14,5kg > > Norwegian - GBP - 15kg > > Norwegian - USD - 0,5 pounds > > Norwegian - USD - 1 pounds > > Norwegian - USD - 1,5 pounds > > Norwegian - USD - 2 pounds > > Norwegian - USD - 2,5 pounds > > Norwegian - USD - 3 pounds > > Norwegian - USD - 3,5 pounds > > Norwegian - USD - 4 pounds > > Norwegian - USD - 4,5 pounds > > Norwegian - USD - 5 pounds > > Norwegian - USD - 5,5 pounds > > Norwegian - USD - 6 pounds > > Norwegian - USD - 6,5 pounds > > Norwegian - USD - 7 pounds > > Norwegian - USD - 7,5 pounds > > Norwegian - USD - 8 pounds > > Norwegian - USD - 8,5 pounds > > Norwegian - USD - 9 pounds > > Norwegian - USD - 9,5 pounds > > Norwegian - USD - 10 pounds > > Norwegian - USD - 10,5 pounds > > Norwegian - USD - 11 pounds > > Norwegian - USD - 11,5 pounds > > Norwegian - USD - 12 pounds > > Norwegian - USD - 12,5 pounds > > Norwegian - USD - 13 pounds > > Norwegian - USD - 13,5 pounds > > Norwegian - USD - 14 pounds > > Norwegian - USD - 14,5 pounds > > Norwegian - USD - 15 pounds > > Norwegian - EUR - 0,5 pounds > > Norwegian - EUR - 1 pounds > > Norwegian - EUR - 1,5 pounds > > Norwegian - EUR - 2 pounds > > Norwegian - EUR - 2,5 pounds > > Norwegian - EUR - 3 pounds > > Norwegian - EUR - 3,5 pounds > > Norwegian - EUR - 4 pounds > > Norwegian - EUR - 4,5 pounds > > Norwegian - EUR - 5 pounds > > Norwegian - EUR - 5,5 pounds > > Norwegian - EUR - 6 pounds > > Norwegian - EUR - 6,5 pounds > > Norwegian - EUR - 7 pounds > > Norwegian - EUR - 7,5 pounds > > Norwegian - EUR - 8 pounds > > Norwegian - EUR - 8,5 pounds > > Norwegian - EUR - 9 pounds > > Norwegian - EUR - 9,5 pounds > > Norwegian - EUR - 10 pounds > > Norwegian - EUR - 10,5 pounds > > Norwegian - EUR - 11 pounds > > Norwegian - EUR - 11,5 pounds > > Norwegian - EUR - 12 pounds > > Norwegian - EUR - 12,5 pounds > > Norwegian - EUR - 13 pounds > > Norwegian - EUR - 13,5 pounds > > Norwegian - EUR - 14 pounds > > Norwegian - EUR - 14,5 pounds > > Norwegian - EUR - 15 pounds > > Norwegian - GBP - 0,5 pounds > > Norwegian - GBP - 1 pounds > > Norwegian - GBP - 1,5 pounds > > Norwegian - GBP - 2 pounds > > Norwegian - GBP - 2,5 pounds > > Norwegian - GBP - 3 pounds > > Norwegian - GBP - 3,5 pounds > > Norwegian - GBP - 4 pounds > > Norwegian - GBP - 4,5 pounds > > Norwegian - GBP - 5 pounds > > Norwegian - GBP - 5,5 pounds > > Norwegian - GBP - 6 pounds > > Norwegian - GBP - 6,5 pounds > > Norwegian - GBP - 7 pounds > > Norwegian - GBP - 7,5 pounds > > Norwegian - GBP - 8 pounds > > Norwegian - GBP - 8,5 pounds > > Norwegian - GBP - 9 pounds > > Norwegian - GBP - 9,5 pounds > > Norwegian - GBP - 10 pounds > > Norwegian - GBP - 10,5 pounds > > Norwegian - GBP - 11 pounds > > Norwegian - GBP - 11,5 pounds > > Norwegian - GBP - 12 pounds > > Norwegian - GBP - 12,5 pounds > > Norwegian - GBP - 13 pounds > > Norwegian - GBP - 13,5 pounds > > Norwegian - GBP - 14 pounds > > Norwegian - GBP - 14,5 pounds > > Norwegian - GBP - 15 pounds > > > > On Sat, May 19, 2012 at 10:08 AM, Tony <[email protected]> wrote: > > > >> Is there no way to put two scenarios (currencies and weights) inside > >> another scenario (languages)? > >> > >> Thanks! > >> > >> Tony > >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
