Drop Down List:make the selection

**diannk** · 08-18-2007, 08:20 PM

Hello,

My question is:

If I have a drop down in column A and the user makes a selection then again I have the same drop down in column J how can I make the selection they made in column A be the default for column J? I want them to be able to make a new selection but I want it to default if the selection would stay the same.

Thanks in Advance,
Diann

**davesexcel** · 08-19-2007, 11:31 AM

a worksheetchange event could do the trick

right click on the sheet tab and select view codes
paste this code there

Please Login or Register  to view this content.

this is if A1 and J1 have the data validation dropdown menus

macros must be enabled for this to work

**Stuart Farr** · 08-19-2007, 12:13 PM

In cell J5 for example, type =A5. Then in cell J5, select Data Validation, select list and choose the same list as you did for cell A5. This then will return the value selected in A5 and give you the same drop down list as for cell A5.

**davesexcel** · 08-19-2007, 12:40 PM

Originally Posted by Stuart Farr

In cell J5 for example, type =A5. Then in cell J5, select Data Validation, select list and choose the same list as you did for cell A5. This then will return the value selected in A5 and give you the same drop down list as for cell A5.

Hi,Stuart
Won't that only work for the first time??