I have to keep a "log" on my results with a summary weekly final results.
My worksheet has seven tabs (Monday - Sunday), I need a final 'weekly'
summary on two results in my 'daily' log.
Here what I have:
(cell c4 is my daily total for failures and c8 is my shipping totals for all
For example on Mondays worksheet in cell d5 I have "total failures =" and d6
I have "units shipped ="
in e5 I have the following:
in e6 I have the following:
My problem is:
On Monday I create a new weekly log that carries over the last work day (for
example, copy Friday log to the new week on Monday). There is other data
that is running all the time, so the last work day is carried to the next
When I try to copy the values in e5 and e6 to the new week I get a "ref"
error, if I rewrite it manually it works.
My question is how can I copy e5 and e6 correctly to the new weekly
I hope this is clear and thanks ahead for any help or suggestions.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
For unsubscribe instructions e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] How to movea sum of all worksheet in one summary to a new spreadsheet · dave_
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy