Suggestions for linking drop-down lists and other data

[sam_leslie7]

Please see the second sheet of the attatched file. I need to be able to change any of the different types of loads using a dropdown that will change the values in the tables to the right of the sheet. if for instance i changed the value in the 'Eccentrically applied' column (cell O20) I need not only the two tables to update, but the other force values to corespondingly update. It works at the moment on the number selected in cell I20. If anyone can help that would be great. I realise I have posted this query before but the file is much more complete now so i think it may be easier to understand!

(I don't know how to edit the title of the other thread - can it please be deleted?)

Thanks

-sam

[StephenR]

You may not thank me for saying this but I think it would be much easier if you had one sheet with all your data set out in a normal database and then you could use various Excel tools and formulae. Work up front but it would save you in the long run.

[sam_leslie7]

so there's no way of doing this in the format that I've already created?

[StephenR]

There is, but it will take a braver man than me. Sorry.

[sam_leslie7]

oh well never mind. I'll heed your advice next time and do it on one sheet. cheers anyway!

[VBA Noob]

See if this event macro using select case helps. Bit long but you should be able to pick up the idea.

To see code right click the sheet tab then select view code.

Did the first two to show you the idea

VBA Noob