LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default autocomplete from specific list

Hi,
I have Sheet1 with different names in a column.
In the Sheet2 I have to type in the names in certain cells. What can I
do that I don't need to write the whole name again but after I beggin
typing excel would check the list of names in Sheet1 and help me to
autocomplete it.

Thank you for your suggestions,
stremetzky
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing the autocomplete list in a cell Mike K Excel Discussion (Misc queries) 1 June 12th 07 12:37 PM
AutoComplete list should accept ENTER key as well as TAB johndog Excel Discussion (Misc queries) 0 October 4th 06 09:53 PM
Validation List Autocomplete Guilherme Loretti Excel Discussion (Misc queries) 2 March 22nd 06 01:07 AM
Autocomplete from a list on the worksheet mrdata Excel Worksheet Functions 3 March 4th 06 08:11 PM
autocomplete from a drop down list Dude Excel Discussion (Misc queries) 1 December 8th 04 03:29 AM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"