put the value from active cell in another cell without VBA

[Kulber]

Hello World!

Is there any way to put the value from the selected cell in another cell (even another sheet) without using VBA code?

Thanks in advance.

 

[Rick Rothstein]

"Copy/Paste Special" (select Value in the dialog box) maybe?

 

[Kulber]

No. Maybe I have not explained.

For example: I have values ​​in cells A1:A10 in the sheet1. When I move from one cell to another cell, I want to put the value of the selected cell in another cell in sheet 2 automatically.