Copy/paste a value into the cell with formula

[ColPal]

Hi there,

is it possible to copy a value from one sheet and put it into another cell in another sheet of the same book. The problem is that the target cell alredy contains formula which I want to stay. Instead of overcopying the new value I want to merge them. Like this: Formula-"value from the another sheet"

 

[ColPal]

Thanks a ton. It works

 

[Joe4]

You are welcome.
Glad I was able to help!