Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically filling fields
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically filling fields
Many thanks Don - that (well HLOOKUP) seems to be just the ticket.
Appreciate the help. "Don Guillett" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling Data automatically | Excel Discussion (Misc queries) | |||
filling in data automatically | Excel Discussion (Misc queries) | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
Automatically filling in data | Excel Discussion (Misc queries) | |||
Filling fields when sending a workbook. | Excel Discussion (Misc queries) |