Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 153
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Invoice Template Excel Invoice Template Currency Excel Discussion (Misc queries) 19 August 31st 06 06:09 PM
Excel Template Invoice redheadokie Excel Discussion (Misc queries) 1 August 17th 06 01:56 AM
How do I generate a new invoice number when creating new invoice? KiddieWonderland Excel Discussion (Misc queries) 1 March 15th 06 03:19 AM
How do I change the invoice number assigned in Invoice template... akress Excel Discussion (Misc queries) 1 February 28th 05 06:36 PM
Excel 98 Invoice Template Guntherg Excel Worksheet Functions 1 December 13th 04 12:05 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"