Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.