Formula or Argument in excel Closed

Question

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

rizvisa1 · Answer

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

Formula or Argument in excel

1 response

Similar discussions

Subscribe To Our Newsletter!