Hi - don't know if this is possible but I've got 4 lists in columns A to D. I was intending to have a validation list (in E4) where the user chooses one of four headings (relating to columns A-D) - then depending on the heading chosen a second validation list (E5) displays the relevant list to that heading, e.g. choice 1 would be column A, choice 2 column B and so on.
Could anyone point me in the right direction please?
Cheers,
rrenis
Could anyone point me in the right direction please?
Cheers,
rrenis