Hey Excel Gurus,
A quick question - I have tried to google around as in my head this seems like a straight forward thing.
I basically want the excel autocomplete/predictive typing in Sheet 1 Column C to pull the prediction text (used for autocomplete, whatever you want to call it) from a list on names that is in Sheet 2.
Is thee a straight forward way to do this without having to copy the whole list above the cells in Sheet 1 and then hiding those rows? Also I don't really want a dropdown validation, just straight forward suggestive text.
I have the Sheet 2 names' list as a named range etc; but not sure if what I want to do is viable?
Thanks for any help in advance, much appreciated.