I am creating a form that requires NAME, ADDRESS, PHONE.
I have a worksheet with all of the necessary data. Each piece is within its own cell.
I like the idea of a Drop Down where I select the NAME and all of the other data follows.
I understand how to create a Drop Down and achieve single cell input, but that's where it ends.
Can anyone guide me to sucess?
No need to start a new thread. You can post to the old one to "bump it" if you felt it wasn't getting attention. (Sorry, I was sick yesterday.)
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.