Could anybody help, in a spread sheet I would like to have a top row of dropdown lists, this I can do, when selecting any cell in the row directly below the drop down, having selecting a value from the dropdown list it is putt into the originaly selected cell. I.e. If A1 has a dropdown with values 1 to 10 in it, selecting cell A10, then selecting a value from the list, thus transporting the value from A1 to A10. If this cannot be done due to A10 automaticaly being de selected when the list in A1 is selected, could then a selected cell, say A5 import the value from A1's list and then ignore any change in A1 once the selected cell A5 has a value in it? Hope someone can help, my heads starting to throb!!
Cheers Andy Hickson
Cheers Andy Hickson
