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 days). For example on Mondays worksheet in cell d5 I have "total failures =" and d6 I have "units shipped =" in e5 I have the following: =sum(c4+Tuesday.c4+Wednesday.c4+Thursday.c4+Friday.c4+Saturday.c4+Sunday.c4) in e6 I have the following: =sum(c8+Tuesday.c8+Wednesday.c8+Thursday.c8+Friday.c8+Saturday.c8+Sunday.c8) 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 week. 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 worksheet? I hope this is clear and thanks ahead for any help or suggestions. -- View this message in context: http://nabble.documentfoundation.org/How-to-movea-sum-of-all-worksheet-in-one-summary-to-a-new-spreadsheet-tp4018041.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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