Page 1 of 1
[Solved] Set value of a cell to value in current cell
Posted: Sat Jul 31, 2021 3:07 am
by MAM593
Is there a function or method to set the value of another cell in the spreadsheet to the value of the current cell?
Re: Function to set value of a cell to value in current cell
Posted: Sat Jul 31, 2021 6:44 am
by Zizi64
The Cell functions can modify the result only in the cell, where they was called from.
This means one cell for "normal" functions or more cells for array functions.
If you want repeat a value of a specific cell (A1) in an another cell (B1) then use a simple reference in the another cell:
Re: Function to set value of a cell to value in current cell
Posted: Sun Aug 01, 2021 7:07 pm
by MrProgrammer
MAM593 wrote:Is there a function or method to set the value of another cell in the spreadsheet to the value of the current cell?
This is the method:
• Edit → Copy (in current cell)
• Select another cell
• Edit → Paste Special → Options:
Link
• These choices are probably already set: Selection: Paste All → Operations: None → Shift Cells: Don't
• OK
You can
record a macro to perform the last three steps.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know