Transferring data between spreadsheet cells

Discuss the spreadsheet application

Transferring data between spreadsheet cells

Postby The Doc » Fri Feb 09, 2018 9:45 pm

how do I transfer the contents of a cell in one spreadsheet to a cell in another spreadsheet so that it is updated from one to the other as the cell content is changed.
openoffice 4.1.1 on Mac
The Doc
 
Posts: 5
Joined: Sat Mar 21, 2015 9:41 pm

Re: transferring data between spreadsheet cells

Postby MrProgrammer » Fri Feb 09, 2018 11:44 pm

Screen Shot 2018-02-09 at 15.35.42 .png
The forum where you posted (Tutorials → Calc) is for tutorials. You cannot ask questions in that forum. I've asked a moderator to move this post to Applications → Calc.

The Doc wrote:how do I transfer the contents of a cell in one spreadsheet to a cell in another spreadsheet so that it is updated from one to the other as the cell content is changed.
Say the first cell you referenced is D5 and the second cell is P4. In P4, put formula =D5. That tells Calc to use D5's value in P4. If you change D5, cell P4 is immediately changed too.

Note, though, that the content transfer is one way only. If P4 is copying D5's content it is not possible using spreadsheet functions for D5 to also copy P4's content so that changing either cell will cause the other to change. You can change P4, of course, replacing the =D5 formula with some other content, but D5 will be unaffected.

[Tutorial] Ten concepts that every Calc user should know
[Tutorial] Mac FAQ

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3504
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 39 guests