Sunday, May 12, 2013

Pagemonth Files Reusability

One of our Pagemonth Budgets and Templates' most valuable features is the fact that one can reuse them year after year without expense.

As a spreadsheet author I note what visitors use for search keywords, and many are seeking home budgets for 2014. as if they were looking for a new car model.

Making a 2013 Pagemonth Budget a 2014 Pagemonth Budget is as simple as changing cell O1 from 2013 to 2014 and saving it as the correct year, then saving it to a safe location not on the desktop.  2014 will be automatically copied to each page and the summary.

But that is only half of the task.  The other half is renaming the file Budget14.(xls or xlr) and saving it as Budget14.(xls or ,xlr)  Because so far you now have a 2014 budget named Budget13.(xls or xlr).

When you rename any of our files be sure to designate the year correctly within the filename before you save it, and we further recommend you keep all of our budgets and templates except the current files you are working with off of the desktop and safely saved in My Documents or other safe locations. 

The correct year's filename protects it from being confused with any other.  So if you type the right year into cell O1, then name it Budget(year).xls or xlr before saving it, it should always be the file you expect when you click its icon.

And that procedure makes all our files reusable at no further cost for as many years as you care to use them.  I have mine dating back to 2008 and still refer to them regularly.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.