| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autocomplete question
Is there any way to have Excel Autocomplete based on a range in an adjacent
worksheet (not just on the rows above)???? I have a worksheet with several cells using data validation drop-down to reference the prior worksheet, but I'd also like to have the option of typing in the entry and having it autocomplete based on the list from the prior worksheet as well..... Thanks! Marika :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
| Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) | |||
| Autocomplete based on a different worksheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
