I have my checkbook register in Writer now. It started back in September of 2013. So, in order to get to January 2015, I have to do a long scroll down to January 2015. I’d like to try saving the individual months on separate sheets. I’d have to copy & paste for each month onto a separate sheet. Then I want to gather sheets for a particular year into one document. So, I’d have a file for 2013 & a file for 2014 & a file for 2015, etc. How do I do that?
I’m attaching a checkbook register file for Calc as a guide. In the template, you will need to create a sheet for each month of the year and save it as 2014 for example. To do that, right click on one of the sheet names, choose Move/Copy Sheet, select Move to end position and give it the name Mar. Repeat for other months. Save it with the filename 2014. Then select Jan 2014 data from your Writer document and paste it into the Jan. sheet in the template. Continue with the other months. Save the document. Open the template again, save it as 2015 and begin pasting the 2015 data into it.checkbook-reg.ots