Hi,
I'm new to the forum.
I need some help with drop-down lists in Microsoft Excel 2007.
I have 9 cells (3 rows and 3 columns), and I created a drop down list of the second column, in another cell. I want the two cells to the left and right of the cell with the drop-down list to change their values like the originary cells.
Maybe this picture will explain better what I'm trying to do.





(Obviously, same thing for A (1,X) and C (3,Z).

Is this possible?

Thanks in advice.