Thread
:
Automatically filling fields
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Automatically filling fields
You could probably get away with just using VLOOKUP from a table with the
data.
=vlookup(name,lookuprange,2,0)
=vlookup(name,lookuprange,3,0)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"answerproject" wrote in message
...
I'm putting together a form on Excel for compiling financial information
from
13 project partners. I want to make it as simple as possible, so ideally
want all the information that flows directly from who's filling in the
form
to be inserted automatically. Is this possible?
i.e. when they select their name from a dropdown list, the fields relating
to address, country, allocated budget, etc are automatically filled in.
Thanks for any help.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett