ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating Excel Invoice Template (https://www.excelbanter.com/excel-discussion-misc-queries/249539-creating-excel-invoice-template.html)

Sasha K

Creating Excel Invoice Template
 
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

Don Guillett

Creating Excel Invoice Template
 
http://www.google.com/search?sourcei...mplates +free

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sasha K" wrote in message
...
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


Gord Dibben

Creating Excel Invoice Template
 
Post the URL of the downloaded template.


Gord Dibben MS Excel MVP

On Sat, 28 Nov 2009 13:46:01 -0800, Sasha K
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



zvkmpw

Creating Excel Invoice Template
 
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.


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com