Hello,
I'm trying to figure out the best/most robust/most efficient/fastest way of limiting data entry in cells based on an entered value in another previous cell;
For example, I have a table (and associated form) for which one of the compulsory items to enter is one of ten possible 5-letter text 'species code'.
Later in the table there are 22 other cells for number entry (measurements) which all have maximum and minimum possible values depending on which 'species code' was selected. Eg, limb length must be greater than 21 but less than 32 for species 'XXXXX'.
I am looking for suggestions for the best way of achieving this - I have seen a few possible suggestions on various forums, and have some ideas of my own, but am open to suggestions, as I'm only an intermediate user.
I greatly appreciate any replies. Thank you.