PDA

View Full Version : Solved: Data Validation - ListBox to look at another worksheets criteria



ads_3131
03-09-2011, 03:59 AM
Help needed once again......... Possibly is a simple one.

Trying to make a list box on sheet one using data-validation but how can i set it to look at certain cells on sheet two :S

:(

ads_3131
03-09-2011, 04:02 AM
Solved it naming the range of cells ....... then refering to the name within data validation :D