I have a list that is dependant upon another list and it will not autofill the cell while typing. It is restricted for one, issue but does not show any of the autofill text. I have tried inserting all my text in the same column above and hiding the cells and it still does not autocomplete. Any ideas?
I want to autofill Column B while typing, it is a merged cell with D, however.
I am attaching a copy of the file.
Invoice-template_2.xlsm
None of the sheets has B merged with D, so it is hard to tell what you want. But autocomplete only works once you have completely identified a unique string. So if you have
Base Package Cabinet HW
Base Package Carpet
you would need to type all the way to
Base Package Cab
before the automcomplete would offer
Base Package Cabinet HW
Better to use data validation lists, and select from the dropdown arrow.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks