Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create quotation template
Hi,
I am creating a quotation template, sometimes a few pages is needed depending on no. of items quoted. I have created the same template on 5 worksheets for different pages. However, how can I have the total amount appear only on the last page only and "continue on next page" to appear on every page before the last page. AN |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create quotation template
Hi
I have been using a quoting system for many years now, consisting of basically two Excel files. It caters for quotations of varying lengths, from as little as a single line to as many as 100 lines. It consists of an input sheet, where you can do calculations etc, and then an output sheets. Data is transferred from the input sheet to the output sheet with a macro, while quotes are numbered alpha numerically, and saved in a folder for the relevant month. Would you be interested? If so, contact me and I will pass it on to you. there is no cost involved. -- Hth Kassie Kasselman Change xxx to hotmail "AN" wrote: Hi, I am creating a quotation template, sometimes a few pages is needed depending on no. of items quoted. I have created the same template on 5 worksheets for different pages. However, how can I have the total amount appear only on the last page only and "continue on next page" to appear on every page before the last page. AN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template or solution for quotation anywhere? | Excel Discussion (Misc queries) | |||
Quotation template whith automatic increments quote ref | Excel Programming | |||
Creating Sequential Numbering Macro for an Quotation template | Excel Programming | |||
Quotation Template that gives options for each item | Excel Programming | |||
What do you use for a quotation template? | Excel Programming |