You could use this code in the Worksheet_SelectionChange event.

If Target.Address = ("$E$1") Then Range("A15").Value = Range("G5").Value

You can access this by right clicking on the worksheet in question and
choosing view code.

Change the drop down box showing General to Worksheet and the
SelectionChange event should automatically appear.

Cheers,
Matt

"ronreggin" wrote:

Is there a way for me to select a cell and then have the information in
another cell change values?

i.e.
I select cell E1 by clicking on the cell with my mouse. I would like the
information in cell A15 to change to a stored value in another cell, G5.

Is this possible?