Currently Being ModeratedDec 1, 2012 10:56 AM (in response to StellaPerLee)
well, I did learn to save my tables as "my templates" at this point ... so I can paste blank tables into my 2013 expense spreadsheet
if I don't figure out how to copy the whole thing.
Also I am talking to myself at this point ... don't know how to do otherwise to add my progress.
This is table 37 although I put it first for review.MacBook (13-inch Late 2006), OS X Mountain Lion (10.8.2), using Numbers from iWork 9 ver 2.2
Currently Being ModeratedDec 1, 2012 11:42 AM (in response to StellaPerLee)
To Duplicate a Document, you use the Duplicate command. You can find this command in the File menu, and also by clicking the Document Name banner of the Numbers Window. You can also invoke Duplicate by typing the key combination Shift-Command-S.
After Duplicating, it is important to immediately File > Save, or Command-S. This gives you the opportunity to Name your duplicate document.
Currently Being ModeratedDec 1, 2012 11:56 AM (in response to StellaPerLee)
This is a general answer, but it should apply to your situation.
My main assumption is that your 36 (or 37) tables are all in one document.
Start by opening your 2012 spreadsheet.
Go File > Save as Template...
Use the name "Temporary-Expenses"
Close the 2012 file.
From the Template Chooser, open the "Temporary-Expenses" template.
In the Untitled document that opens:
Clear (delete) all of the entered data.
Do not delete the Labels.
Do not delete the formulas.
Data includes amounts that you have entered, Dates you entered for those income and expense entries and descriptions you have entered for those income and expense entries.
If any of this has been entered using pop-up menus, then "clearing" the entries can be done by setting the first pop-up in a column to 'blank', then Filling that cell down the rest of the column.
Data entered by checking a checkbox can be handled in a similar manner: Uncheck the first box in a column, then Fill down through the rest of the column.
If you manually entered a Starting Balance, that should also be cleared.
When the document has been cleared of all entered data, go File > Save as Template, this time using the name "Annual Income and Expenses" (or something similar).
At this point, you will have two saved templates plus an open "untitled" document that is the same as you would get by opening the last template saved.
From the template Chooser, open a second copy of the "Annual Income and Expenses" template (It will open as "untitled 2" or similar). Do enough test entries that you are satisfied the template produced spreadsheet works like the original, then trash the first 'untitled' document you used to create the template and either clear the one on which you ran the tests and save it as your 2013 version, or trash that one as well, and open a new, empty, copy to use for 2013.
Currently Being ModeratedDec 1, 2012 11:42 PM (in response to Barry)
well, thanks! I am learning and tweaking the Temporary-Expenses left and right ... had a lot of problems so will need a couple of days then will get back to you that "I got it" OR with more questions!
Learned these are Tables that I am using and learned the hard way how to get the colored columns and rows out; how to make the rows same height; how to stop things from moving all over! (lock) ... in short, Thanks and not done yet!
Currently Being ModeratedDec 2, 2012 5:34 PM (in response to StellaPerLee)
This suggestion may seem a bit tardy, but it doesn't appear that you have had the benefit of reading the Numbers User Guide, and I'm sure that you would enjoy this well-written document.
You can download it via a link in the Help menu.
Currently Being ModeratedDec 2, 2012 7:00 PM (in response to Jerrold Green1)
LOL no I haven't! will download it but might not read it before Christmas ... thanks!
Currently Being ModeratedDec 3, 2012 9:09 AM (in response to StellaPerLee)
You can read the first three or four chapters in an easy evening with a pot of tea. Well worth the investment to get just that far.