I dont have experience on Excel, but I need to create a list Box. I have
placed Named Lists which will be the choices in the Data Validation cells on
a different worksheet on the same work book. When I use the Validation to
populate the data on the drop down box on another worksheet, I get a message
€œYou may not use reference to other worksheets or workbook for data
validation€� What does this means?
All I wont is having the data source of the drop down list on a different
worksheet. .Is this possible please ?

--
Bob