 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Auto-complete list question
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 Dear Pete Burns, I think an example will solve your problem. Say, in excel worksheet sheet2 you have the list- A B C 1Nazmul 2Haque 3Rony 4Pete 5Burns 6Bangladesh Again, in excel worksheet sheet1 click on cell number say A1. Now clic on the menu “Data” then “Validation” then on settings tabs Allow the select “List” the a new field “Source” will flash out ,now click tha blank field then click on the :Sheet2” then Select the range from cel A1 to A6 then press Enter/Ok then go to sheet 1 and click that cell an on its left corn a plus sign will come then click there and move it dow as long as as you need in that column. - A B C 1 + 2 3 4 5 6 Wish you Good Luck. *Nazmul Haque Bangladesh MAERSK -- rony4ica Posted from - http://www.officehelp.i If you want to use data|Validation, Debra Dalgleish has some instructions: http://www.contextures.com/xlDataVal01.html#Name But data|validation doesn't autocomplete. > 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 [quoted text clipped - 3 lines] > Auto-complete and the list is not ordered like the weeks or months > Thanks  SignatureDave Peterson > 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 [quoted text clipped - 3 lines] > Auto-complete and the list is not ordered like the weeks or months > Thanks I think I have it now, sorry about the last post Pete > 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 [quoted text clipped - 3 lines] > Auto-complete and the list is not ordered like the weeks or months > Thanks 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 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 >> 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 [quoted text clipped - 12 lines] >Thanks >Pete DEAR PETE BURNS Thanks for your reply & hope you best of your luck. *Nazmul Haque Bangladesh MAERSK -- rony4ica Posted from - http://www.officehelp.i |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.