Auto-complete list question

P

Pete Burns

I am not an advanced user, so when you have a column of text and you
enter data in a new cell if the entry exists all ready in the column it
will appear, if you want that entry you hit enter. The question is how
can I store that list on another worksheet without the whole column
showing, so I can quickly enter the same data ? I am not sure if this is
Auto-complete and the list is not ordered like the weeks or months
Thanks
 
G

Gord Dibben

Pete

You can use a list from another sheet if you name the list range.

See Dave's post and the link to Debra's site.


Gord Dibben MS Excel MVP
 
P

Pete Burns

Pete said:
I am not an advanced user, so when you have a column of text and you
enter data in a new cell if the entry exists all ready in the column it
will appear, if you want that entry you hit enter. The question is how
can I store that list on another worksheet without the whole column
showing, so I can quickly enter the same data ? I am not sure if this is
Auto-complete and the list is not ordered like the weeks or months
Thanks
Click to expand...
Thanks for the quick answers. It seems to do what I had hoped for, BUT
Nazmul if you check back here: The Data validation does not allow me to
go to another worksheet. I tried to get to the cell in different ways. I
can get around that by copying my list to each worksheet and then
hiding it, but if I am missing something let me know. Oh I am using
Excel 2000 version if that helps

Thanks
Pete
 
P

Pete Burns

Pete said:
I am not an advanced user, so when you have a column of text and you
enter data in a new cell if the entry exists all ready in the column it
will appear, if you want that entry you hit enter. The question is how
can I store that list on another worksheet without the whole column
showing, so I can quickly enter the same data ? I am not sure if this is
Auto-complete and the list is not ordered like the weeks or months
Thanks
Click to expand...

I think I have it now, sorry about the last post

Pete
 
Top