software

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 gt; Name gt;
Define, enter a name for your list (say EntryList) and click amp; 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 gt; 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

quot;zzzapsquot; wrote:

gt; Is ther a way to force the Auto Complete to reference another sheet? What i
gt; want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto
gt; complete data. That way I can prevent entry of incorrect data, only leting in
gt; what i have listed on the sheet 2. The list function works but you have to
gt; pick the data from the list, there must be a way to start entering the data
gt; 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.

quot;bpeltzerquot; wrote:

gt; I don't believe you can have AutoComplete 'learn' from another sheet. But
gt; you could use Data Validation so that the users can select from a drop-down
gt; list and have the valid entries restricted to the list you supply.
gt; Suppose the valid list is in Sheet2, cells A1:A6. On sheet, Insert gt; Name gt;
gt; Define, enter a name for your list (say EntryList) and click amp; drag to
gt; indicate the cells holding the list: Sheet2!A1:A6. After you've defined the
gt; name, in the cell(s) where data should be entered, use Data gt; Validation.
gt; Use the drop-downs to indicate that Excel should allow a List, and the source
gt; is =EntryList.
gt; Now the users can select rather than type, and you can pop up a warning if
gt; they type something that's not on the list.
gt; HTH. --Bruce
gt;
gt; quot;zzzapsquot; wrote:
gt;
gt; gt; Is ther a way to force the Auto Complete to reference another sheet? What i
gt; gt; want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto
gt; gt; complete data. That way I can prevent entry of incorrect data, only leting in
gt; gt; what i have listed on the sheet 2. The list function works but you have to
gt; gt; pick the data from the list, there must be a way to start entering the data
gt; gt; and it would auto fill from the sheet 2 list.