Previous Topic Next Topic

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

Answer 1 / 1
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
0
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response