Hi,

Can anyone tell me how to create a drop down list based on a number of cells not in a line.

Im using Data Validation lists but then i select multiple cells (holding shift) I receive an error?

Many thanks

Matt