I have been trying to customize a downloaded template but was frustrated so
trying to create my own invoice. My question is once I input the formulas
how do I keep/save them ???? when I enter the first calcualtions all is well,
but if I go back and edit in the cell where the formula resides I lose the
formula ??? I am a relative newbie to this so any help will be greatly
appreciated. I have searched this site and cannot find a link to creating an
invoice worksheet.
Sasha

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

http://www.google.com/search?sourcei...templates+free

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Sasha K" <(E-Mail Removed)> wrote in message
news:7AA6E0B8-785C-44D8-BDEF-(E-Mail Removed)...
>I have been trying to customize a downloaded template but was frustrated so
> trying to create my own invoice. My question is once I input the formulas
> how do I keep/save them ???? when I enter the first calcualtions all is
> well,
> but if I go back and edit in the cell where the formula resides I lose the
> formula ??? I am a relative newbie to this so any help will be greatly
> appreciated. I have searched this site and cannot find a link to creating
> an
> invoice worksheet.
> Sasha
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc

Post the URL of the downloaded template.


Gord Dibben MS Excel MVP

On Sat, 28 Nov 2009 13:46:01 -0800, Sasha K
<(E-Mail Removed)> wrote:

>I have been trying to customize a downloaded template but was frustrated so
>trying to create my own invoice. My question is once I input the formulas
>how do I keep/save them ???? when I enter the first calcualtions all is well,
>but if I go back and edit in the cell where the formula resides I lose the
>formula ??? I am a relative newbie to this so any help will be greatly
>appreciated. I have searched this site and cannot find a link to creating an
>invoice worksheet.
>Sasha
>
>----------------
>This post is a suggestion for Microsoft, and Microsoft responds to the
>suggestions with the most votes. To vote for this suggestion, click the "I
>Agree" button in the message pane. If you do not see the button, follow this
>link to open the suggestion in the Microsoft Web-based Newsreader and then
>click "I Agree" in the message pane.
>
>http://www.microsoft.com/office/comm...lic.excel.misc

> My question is once I input the formulas
> how do I keep/save them ???? when I enter the first calcualtions all is well,
> but if I go back and edit in the cell where the formula resides I lose the
> formula ???

It's usually best to think ahead and decide (a) which cells are to
contain constant values to be edited and (b) which are to contain
formulas depending on the constants (and on other formulas).

Typically, one wouldn't replace a formula with a constant.

In the case at hand, perhaps two cells are needed:
- one to be edited for each calculation, and
- a second with a formula doing some calculation.