Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down lists that populate other cells
I need some help with an Excel spreadsheet.
So however you can make this work - i'll try. Basically I have a drop down list/box in B11 with my customers names, (the simple drop down box i can do) - but i want to select a company from the drop down box in B11 and the sheet to automatically populate the customers information in subsequent cells. For example. In B11 I choose Company A. than elsewhere on the worksheet this selection should trigger text to appear in J11 (the company's name again: Company A), J12 (the company's address: 123 Main St.), and J13 (the city informaton: Charlotte, NC 20000). I couldnt figure out how to do this so i was going to opt for a two drop down boxes, a simple one in B11-just easily choosing the company's name to fill the blank, and THEN a complex one in J11 (which would populate to two cells below it). However i cannot figure out to make it so a selection in the drop down in J11 will also populate the necessary information in J12 & J13. So then i was trying to figure an "IF" type function, if B11 = "Company A", then B12 = "123 Main St." and B13 = "Charlotte, NC 20000". I could not make it do anything remotely similar to this. I have Macro's applications working elsewhere in this worksheet as well for much simplier tasks, but i am concerned with doing this for these addresses because there are upwards of 300 different company's & address to assign a Macro's to, and it just seems like there is an easier way to go about this. Finally, i have come across this VisualBasics (or something like that), while trying to research how to do this - but i know nothing about this...sooo.... please help if you can. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Cells with Drop Down Lists | New Users to Excel | |||
Copying Cells with Drop Down Lists | Excel Worksheet Functions | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) |