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