View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 515
Default 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