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.

I don't believe you can have AutoComplete 'learn' from another sheet. But
you could use Data Validation so that the users can select from a drop-down
list and have the valid entries restricted to the list you supply.
Suppose the valid list is in Sheet2, cells A1:A6. On sheet, Insert Name
Define, enter a name for your list (say EntryList) and click & drag to
indicate the cells holding the list: Sheet2!A1:A6. After you've defined the
name, in the cell(s) where data should be entered, use Data Validation.
Use the drop-downs to indicate that Excel should allow a List, and the source
is =EntryList.
Now the users can select rather than type, and you can pop up a warning if
they type something that's not on the list.
HTH. --Bruce

"zzzaps" wrote:

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.

Thanks, I half expected that and have it setup the way you mentioned. I am
referencing over 250 items and wanted a shortcut.....oh well.

"bpeltzer" wrote:

I don't believe you can have AutoComplete 'learn' from another sheet. But
you could use Data Validation so that the users can select from a drop-down
list and have the valid entries restricted to the list you supply.
Suppose the valid list is in Sheet2, cells A1:A6. On sheet, Insert Name
Define, enter a name for your list (say EntryList) and click & drag to
indicate the cells holding the list: Sheet2!A1:A6. After you've defined the
name, in the cell(s) where data should be entered, use Data Validation.
Use the drop-downs to indicate that Excel should allow a List, and the source
is =EntryList.
Now the users can select rather than type, and you can pop up a warning if
they type something that's not on the list.
HTH. --Bruce

"zzzaps" wrote:

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.