Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

RockSolid101010

macrumors newbie
Original poster
Oct 28, 2009
4
0
Is it possible to have Data Validation set up so that the person can type into the cell and have the text auto complete based on the range that the DV is pulling from?

I'm making a sheet and the range I want to pull from has 500+ values. I can't sit and wait for the list to scroll it takes FOREVER I and am trying to find a solution.

I've found a bunch of threads on other excel forums but they all either lead to a dead end (probably because the writer was on a PC) or the solution just didn't work.

Any ideas?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.