Copy / paste contents of specific cell on double-click

Greetings EXCELlenters,

Absolute greenhorn here.

I want to be able to:
double-click on a cell to...
copy the entire content of a cell in the same line, but always the SAME (known) column, to the cell in which I double-clicked.

EXAMPLEs:
--->> double click on C3, to copy the entire content (color and text content) of Q3 to C3
--->> double click on E5, to copy the entire content (color and text content) of Q5 to E5
--->> double click on B22, to copy the entire content (color and text content) of Q22 to B22

I wish this 'macro'(?) to be retained with my document, and NOT part of my EXCEL configuration.

Many thanks, con ger

Thanks Daff

The greenhorn strikes again.... tab name... can you explain pls.

-g-

Cool Daff... managed to get the tab name bit... and it works... mostly... the cell content (text) is copied and pasted... but the color (of the cell to be copied) is not, nor is the color of the text copied... else, just what I want!

Daff.... eternally grateful... large numbers of feedback sheets to be recorded... was mighty cheesed at the C&P effort... no... just a (double)click... and I am done.... thanks, g.

PS.... Daffodil.... national flower.... of Wales? -g-

Now... the next requirment.

Limit this function (2-clich / replace) to a specific range of lines.... I.E. it works in lines 7 to 85... but not in any other line?

;-))

-g-

Originally Posted by daffodil11

=D

Actually, it's the middle name of a character from one of my favorite novels.

http://en.wikipedia.org/wiki/Slapstick_(novel)

Aha..... read the wiki.... now on my amazon wish list... ta, g.