Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a drop down list of branch names in one sheet. The source sheet
(separate one) contains the values of this list and addresses and contact information, as well. I need to populate adjacent cells in the one sheet with the respective addresses and contact information, matching the selected branch name. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
EXCEL 2007
Please check out:- http://www.pierrefondes.com/ Item number 57. If you enter numbers (1 to 9 in any order) into worksheet_1 cells A2 to A10 it will pull back the corresponding values into worksheet_1 cells B2 to B10. The, "translation table" is found in worksheet_2. If my comments have helped please hit Yes. "Joe Spindola" wrote: I have a drop down list of branch names in one sheet. The source sheet (separate one) contains the values of this list and addresses and contact information, as well. I need to populate adjacent cells in the one sheet with the respective addresses and contact information, matching the selected branch name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate Data from Summary Sheet | Excel Discussion (Misc queries) | |||
Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
How to populate one sheet with data from another sheet | New Users to Excel | |||
populate cells with data from another sheet | Excel Worksheet Functions |