Your question is not completely clear to me. Are you asking to have the
value in O14 assigned to N14 whenever the user selects D18? If so, what to
you want displayed in N14 when some other cell is selected? Nothing? Or do
you have other assignments you want made for other cells when they are
selected? If so, you should list them all for us.

--
Rick (MVP - Excel)


"wietsche" <wietsche @discussions.microsoft.com wrote in message
...
I click on D18 =(Formula?)N14 but must show O14