[Solved] Inserting data from one spreadsheet into another
[Solved] Inserting data from one spreadsheet into another
REMEMBER: I'M A BEGINNER!: I would like to know if it's possible to update the contents of a cell in a target spreadsheet from the value of a cell in a source spreadsheet. I hope I phrased this right.
Last edited by Hagar Delest on Wed Jan 02, 2019 9:29 am, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.4 on windows 10
Re: Inserting data from one spreadsheet into the cell of ano
Open both.
Copy the cell.
menu:Edit>Paste-Special [Ctrl+Shift+V]
In the upcoming dialog check option "Link".
Copy the cell.
menu:Edit>Paste-Special [Ctrl+Shift+V]
In the upcoming dialog check option "Link".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Inserting data from one spreadsheet into the cell of ano
IT WORKED!!!! THANK YOU!!!!
OpenOffice 4.1.4 on windows 10
Re: Inserting data from one spreadsheet into the cell of ano
If you are new to spreadsheets, you may find the following to be useful resources.
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
As you are a newcomer to the forum, may I refer you to the Survival Guide for guidelines on using the forum; especially
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
As you are a newcomer to the forum, may I refer you to the Survival Guide for guidelines on using the forum; especially
Please, no CAPS. Else, it means that you're shouting and it's a quiet place here.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers