Hi Trying to make a drop down list in excel. I have tried the validation
method and cannot seen to get the path correct. I have a speadsheet with say
7 worksheets the first being the main one the rest hold individual data that
I want each cell in the 1st table to look up and give me the choice of
entering individual items from the drop down. What I tried to do was in the
Validation screen selected List but cannot figure out the source info to
enter I have tried =Area!A1:A5 but does not got to sheets 2 called Area and
give me a drop down choich of the data help in cells A1 to A4. Any advice
would be much appreciated.