Formula or Argument in excel

Closed
ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010 - Feb 27, 2010 at 01:38 AM
ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010 - Feb 28, 2010 at 04:01 AM
Hello,

I am looking for a formula to use so that when i pick a person's name from the drop down list a date will appear in the cell next to the name picked from the drop down list. The date to be entered comes from the Master date in cell A26. If no name is in the drop down list then their is to be no date in this cell.

Chris

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 27, 2010 at 08:47 AM
There is no formula for that

You have to use

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub


see this that had pretty much same idea. In fact your is far simpler

https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010
Feb 28, 2010 at 04:01 AM
Thanks for this information
0