Hi :) I can imagine about 3 ways of doing this. 1. Most finance spreadsheets use tons of worksheets within a workbook/single-file. One for each week/month/quarter or whatever. How? Well, near the bottom of your spreadsheet you may notice 3 tabs. These can be renamed and more added. (The ideal way is to figure out the layout of 1 page/sheet, then right-click on it's tab and do "copy". Then each page/sheet becomes an improvement on the last until you get it perfect(ish)). Each tab is known as a "worksheet" but it is still within the same file as the overall file, which is sometimes called a "workbook". This way it's easier to predict exactly which cell will be the figure to "carry forwards". It may also make it easier to have common formulae that are specific to each page but repeated on each page/sheet.
2. Use "Find & Replace" to get to each formula in turn and then edit each one "by hand". This could easily get quite tedious and prone to error through boredom and distractions. 3. Errr, i can't quite remember but it was somehow inspired by Andreas' question. I'm not sure if it was what he was driving at or some weird off-shoot that i hadn't fully thought through. 4. Maybe use a 2nd worksheet/tab that uses formulae to read the results of the correct cells and then gets used (back on the main sheet) to do the calculations. Again this is something i haven't fully thought through and might well not work or might not be feasible in your "use-case" 5. Another approach might be to develop a Database to hold the data and use Calc to generate reports. There might already be a purpose-built template or even a dedicated program we might be able to suggest. Does any of those sound like something to aim for? I think 1 or 5 might be good for the future but maybe the most efficient way to minimise the amount of time to get from where you currently are might be to go for number 2 or 4. It's not very elegant. Andreas' 3 might well be the winner, without my weird off-shoot. Regards from Tom :) On 25 September 2015 at 20:26, Andreas Säger <[email protected]> wrote: > Am 25.09.2015 um 13:20 schrieb Dave Howorth: > > I have a spreadsheet that I need to print and send to the government. > > > > When I print it, I need to print a page subtotal and also repeat that > > subtotal at the top of the next page. > > > > Is there some way to do this apart from doing it all by hand? > > > > Thanks, Dave > > > > Can you guarantee that each page has the same amount of rows? > > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
