Hi,

Is it possible in an Excel sheet to get the data in an empty cell from
another cell at a single click of mouse on the cell which contains that data
or number. Basically, its transferring of a number from one cell to another
without using Copy & Paste. The number or data will come from a cell in a
matrix. Further, is it possible to automatically change the colour of the
cell which is being clicked. Please reply urgently with detail solution to
the problem if achievable by programming or any means, it will be highly
appreciable.


Thanks,
Eddy