I'm wanting to have a drop down/combi box that when a value is selected automatically populates a row of cells with default values that I have already set. I can find plenty on the net about getting it done in just one cell but I want to put information in at least six cells This is basically what I want to do: Select option A and cells A through F are completed like so: Then should I change to say option B A through F change values:</p> </p> </p> Can this be done?? Any info gratefully received. </p>
One way to do it... Use cell validation to create the pull down box. Use the list type to specify in all the possible values. Enter all the default values into a table (maybe on a hidden sheet). Use the lookup function to set the outputs to whatever it says in the table, based on the user's input. Hope this makes sense. Does it sound like it's what you were after? You could of course also use macros.
bugger! Keep forgetting about macros. Spent ages and ages trying to work out how to do a formula the other week. Bet it would have taken seconds with a Macro - doh!
Never mind Always better to achieve what you want without using macros if possible. The problem is macro references don't automatically update if say you move cells around. References in formulae do.
Possibly ... So long as values are assigned to certain cells depending upon the combo box option. For example if it can be set so: If option A is selected - A1=1;B1=2 etc If option B is selected - A1 =11; B1 =22 etc Then that's what I'm after. Never used the look-up function though, I'm guessing that would simply copy and paste from another table where they were all stored? If so, aye, that sounds like what I'm after.
RE: Which version of Excel are you using? Cheers that'd be great thanks ... I'm using 2002. Off to bath the screaming young 'un for half hour so please don't take any silence as lack of gratitude! - Be back once he's snoozing!
RE: Example Cheers for the example - that's exactly what I'm trying to do. Although I've e-mailed you as when I try and redo in another worksheet it doesn't quite seem to work out.
