auto-complete

Excel 365 on Windows 10 I have an Excel sheet with about 2000 rows. In one column, there are names, repeating from a few hundred individual values. Expected: when I type a name in a new row, in this column, auto-complete should find the matching name and fill it in. Observed: for some names it...

Hi all, I have a macro enabled spreadsheet that has multiple auto-complete drop-down lists. When the file is shared the drop-down list did not appear from the selected cell but instead appeared in another cell (see screenshot from the link below). I have also attached the spreadsheet if someone...

Hi all - new to the message board, need a little help. I have some experience with VBA, but I am far from a master. I essentially have a sheet where for each line (maybe 100 lines to a sheet) a reviewer selects a value from a very long drop down list to provide the status for the individual...

Hi all, Sorry if this is already out there and I missed it (in which case, please feel free to share the useful link:) ), but I was wondering if there was anyway to tie settings to a shared document. The details are as follows: I have an excel shared on a server with many other people. To...