Import a template?
 

If I download a budget template from the Microsoft website, is there a
way to insert or import it into a current spreadsheet that I have?

So, for instance, sheet1 would be the mnthly budget (which shows
projected cost and actual cost), sheet2 would be all the data I've
currently been entering which is giving my an overall view of month by
month. Sheet1 would be able to use information from Sheet2 to fill in
the "Actual cost" cells.

My questions are then:
1. Can I utilize a pre-made template in my current file?
2. How do I reference a cell from one worksheet and insert it into
another?

Import a template?
 

You can download the budget template then copy the sheets you want into your
current workbook.

For the cell refencing part see help on "linking"


Gord Dibben MS Excel MVP


On Wed, 03 Sep 2008 12:59:39 -0400, Glory wrote:

If I download a budget template from the Microsoft website, is there a
way to insert or import it into a current spreadsheet that I have?

So, for instance, sheet1 would be the mnthly budget (which shows
projected cost and actual cost), sheet2 would be all the data I've
currently been entering which is giving my an overall view of month by
month. Sheet1 would be able to use information from Sheet2 to fill in
the "Actual cost" cells.

My questions are then:
1. Can I utilize a pre-made template in my current file?
2. How do I reference a cell from one worksheet and insert it into
another?