Is ther a way to force the Auto Complete to reference another sheet? What i
want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto
complete data. That way I can prevent entry of incorrect data, only leting in
what i have listed on the sheet 2. The list function works but you have to
pick the data from the list, there must be a way to start entering the data
and it would auto fill from the sheet 2 list.