Hello,
I have a workbook with multiple worksheets. Is it possible to copy the contents of a cell, say in worksheet A, to a cell in worksheet B so that as the contents in the A sheet are updated/changed those changes will automatically update to the cell in sheet B ?
Thanks,
Bruce
Please note that a formula of the kind @anon73440385 suggested will not “insert data” anywhere, but basically return a formula result to the cell.
If this result is obtained by a single reference, this is only the simplest case in the universe of formulas spreadsheets support - and need to support to be useful.
Hello,
for sure - lets assume what you call “worksheet A” has name Sheet 1 (correction as per comment by @Lupp: Sheet1) and “worksheet B” has name Sheet 2 (correction as per comment by @Lupp: Sheet2, which are the default names of sheets in a Calc spreadsheet document)
In Sheet 2 enter =$Sheet1.A1 into any cell which you want to automatically show the value you entered in Sheet 1 cell A1
Please note: This is not copying content but referencing content. Copying would require macro programming or manual action. Generally speaking: Copying existing data introduces redundancy and redundancy of information should be avoided. Referencing existing information is the way spreadsheet applications work.
Ref.: LibreOffice Help - Referencing Other Sheets
Hope that helps.
The default names of sheets don’t contain spaces, and chosen names also shouldn’t.
To start a sheetname with a digit or to use spaces or special characters in these names is a bad idea causing useless complications.
A first annoyance is the need of using single apostrophes to escape ambiguities.
That did it guys,thanks so much !!!
Problem solved.
Bruce