I was asked how to make an auto complete from a list of cells in another sheet in the same file. I thought the validation would work, but it only supports a scroll bar. That is fine for short lists, but not for hundreds of lines. Any suggestions on how to do this? I have seen it in some apps. I played with VLOOKUP, but it doesn't return a list. If there is no good way to do this, can it be a feature request? Thanks, Dave Sent with [Proton Mail](https://proton.me/) secure email. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy