Hi Eddy

More details needed!

How do I know which cell to transfer data to ? Will it be next empty cell in
a certain column or ....

What is the range you want to transfer data from?

Regards,
Per

"Eddy" skrev i meddelelsen
...
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