Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic data entry in alternate cells based on drop-down menu se
Hello. I am using Microsoft Excel 2003. I am trying to figure out how (or
if) I can get information to populate in multiple cells when choosing a selection from a drop-down that is embedded in just one cell. For example: the spreadsheet that I am working on has three different cells that I want apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor Account.' I have put a drop-down in the 'Vendor Address' cell so that I can simply choose the appropriate vendor from a list. I would like my choice to populate the correct information in the other two cells automatically-- if I select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like the telephone number and account number to automatically populate in the correct cell. Can this be done? I realize I could just put all of the information into one cell/one drop-down, but then I would have to modify the layout of the company's spreadsheet and that would be... frowned upon! Any help is most appreciated! Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic data entry in alternate cells based on drop-down menu se
Try my example he
http://www.officearticles.com/tutori...soft_excel.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "silence13" wrote in message ... Hello. I am using Microsoft Excel 2003. I am trying to figure out how (or if) I can get information to populate in multiple cells when choosing a selection from a drop-down that is embedded in just one cell. For example: the spreadsheet that I am working on has three different cells that I want apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor Account.' I have put a drop-down in the 'Vendor Address' cell so that I can simply choose the appropriate vendor from a list. I would like my choice to populate the correct information in the other two cells automatically-- if I select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like the telephone number and account number to automatically populate in the correct cell. Can this be done? I realize I could just put all of the information into one cell/one drop-down, but then I would have to modify the layout of the company's spreadsheet and that would be... frowned upon! Any help is most appreciated! Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic data entry in alternate cells based on drop-down men
It worked! :) Thank you very much for all of your help!
"Anne Troy" wrote: Try my example he http://www.officearticles.com/tutori...soft_excel.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "silence13" wrote in message ... Hello. I am using Microsoft Excel 2003. I am trying to figure out how (or if) I can get information to populate in multiple cells when choosing a selection from a drop-down that is embedded in just one cell. For example: the spreadsheet that I am working on has three different cells that I want apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor Account.' I have put a drop-down in the 'Vendor Address' cell so that I can simply choose the appropriate vendor from a list. I would like my choice to populate the correct information in the other two cells automatically-- if I select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like the telephone number and account number to automatically populate in the correct cell. Can this be done? I realize I could just put all of the information into one cell/one drop-down, but then I would have to modify the layout of the company's spreadsheet and that would be... frowned upon! Any help is most appreciated! Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic data entry in alternate cells based on drop-down men
So glad to hear it!
**************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "silence13" wrote in message ... It worked! :) Thank you very much for all of your help! "Anne Troy" wrote: Try my example he http://www.officearticles.com/tutori...soft_excel.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "silence13" wrote in message ... Hello. I am using Microsoft Excel 2003. I am trying to figure out how (or if) I can get information to populate in multiple cells when choosing a selection from a drop-down that is embedded in just one cell. For example: the spreadsheet that I am working on has three different cells that I want apply this function to-- 'Vendor Address,' 'Vendor Telephone,' 'Vendor Account.' I have put a drop-down in the 'Vendor Address' cell so that I can simply choose the appropriate vendor from a list. I would like my choice to populate the correct information in the other two cells automatically-- if I select 'ABC Vendor, 122 Main St, Anywhere' from my drop-down I would like the telephone number and account number to automatically populate in the correct cell. Can this be done? I realize I could just put all of the information into one cell/one drop-down, but then I would have to modify the layout of the company's spreadsheet and that would be... frowned upon! Any help is most appreciated! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Data Entry | Excel Discussion (Misc queries) | |||
excel automatic data entry | Excel Discussion (Misc queries) | |||
Automatic data entry | Excel Discussion (Misc queries) | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
drop down menu with calendar entry | Excel Discussion (Misc queries) |