[Solved] Inserting data from one spreadsheet into another

Discuss the spreadsheet application
Post Reply
jayster
Posts: 2
Joined: Wed Jan 02, 2019 1:02 am

[Solved] Inserting data from one spreadsheet into another

Post by jayster »

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. :knock: :knock: :knock:
Last edited by Hagar Delest on Wed Jan 02, 2019 9:29 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.4 on windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Inserting data from one spreadsheet into the cell of ano

Post by Villeroy »

Open both.
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
jayster
Posts: 2
Joined: Wed Jan 02, 2019 1:02 am

Re: Inserting data from one spreadsheet into the cell of ano

Post by jayster »

IT WORKED!!!! THANK YOU!!!!
OpenOffice 4.1.4 on windows 10
User avatar
robleyd
Moderator
Posts: 5087
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Inserting data from one spreadsheet into the cell of ano

Post by robleyd »

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
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
Post Reply