Are you looking to fix the target destination, make a relative reference,
e.g offset by 1 column by 4 rows or say double-click a cell, then select a
target cell and it is copied across?

--

Regards,
Nigel




"lamesakid5810" wrote in message
...
How do i copy the content of a cell and paste it to another cell by just
clicking on the cell you want to copy. For example I want to copy the
content
of A1 to B5 by just selecting cell A1