View Single Post
 
Old 10-05-2012, 07:59 AM
Geza59 Geza59 is offline Windows XP Office 2003
Novice
 
Join Date: May 2012
Location: Budapest, Hungary
Posts: 20
Geza59 is on a distinguished road
Default How to "hard link" two adjacent cells to a data validation drop down list?

Hello to all!

As you can see on the attached Excel file I created a data validating drop down list (B2 -B5) and cannot figure out how to modify the list of the cells in the drop down list so that when I choose an item from the drop down list, not just the current cell but the two cells next right to it would also get updated.

For example, if I choose John from the drop down list, I'd like his building and apartment number also pop in once I let the mouse button go on John:

John A 1

So, maybe I should ask the question: How can you create a drop down list of not one column but two or three columns of lists?

Why I need this feature on the first place instead of merging the building and apartment number info in the first cell? So, that later I could do data sorting based on the building name or apartment numbers.
Attached Files
File Type: xls Data_Validation.xls (13.5 KB, 18 views)
Reply With Quote