Hi,

I need to create two very simple macros and hoped that somebody might be able to help.

The first one needs to change the value in one specified cell to the value in another range of cells when one of them is clicked on.

e.g. if Cell B2 is the specified Cell and the range of cells is A1 to A100. When you click on Cell A2 the value in cell B2 changes to the value in A2.

The second is just that when you click on a cell in a range of cells it takes to one specific chart or worksheet. So if the range was A1 to A100 and you clicked on any of those cells you would be taken to a sheet called template.

Many thanks and any help on either issue greatfully received.

Jack