I have two pages in a workbook. In page one I have lists in cells that are
validated by cells in page 2.
What I would like is, next to the cell that is validated, have a cell that
has a relevant code eg. If cell A1 has a list box that has fruit names in
Apple, pear etc (Validated from A1 in page 2) I would like B1 in page 1 to
have a code for each (Apple = 1, Pear = 2)
So that if a user chooses Apple from the drop down 1 will appear in the next
cell, if they change it to Pear from the list 2 appears etc.