D
des-sa
Hi,
I've had so much help in this forum over the last few days, i'm going to
push my luck now.
I have a master/template sheet, which needs to be copied, the new sheet
autonumbered and certain data recorded. This is for quotes I have to give to
customers on a daily basis. This is what i want to do:
1. First I want to be able to start on the template sheet everytime a new
quote has to be opened. In this sheet is a field for document number. The
new sheet has to add 1 to this number (initially) thereafter to the last
sheet that was saved, in order to keep a sequence of quotes. How? What would
be the simplist practical - to open a new sheet or workbook? If possible, I
would want that new document number to become the tab name of the sheet.
2. Certain cells in every sheet need to be recorded in a different (summary)
sheet where i can ceate a list with the details of clients we quoted for -
say about 12 cells in every sheet need to be listed in columns.
Please help
I've had so much help in this forum over the last few days, i'm going to
push my luck now.
I have a master/template sheet, which needs to be copied, the new sheet
autonumbered and certain data recorded. This is for quotes I have to give to
customers on a daily basis. This is what i want to do:
1. First I want to be able to start on the template sheet everytime a new
quote has to be opened. In this sheet is a field for document number. The
new sheet has to add 1 to this number (initially) thereafter to the last
sheet that was saved, in order to keep a sequence of quotes. How? What would
be the simplist practical - to open a new sheet or workbook? If possible, I
would want that new document number to become the tab name of the sheet.
2. Certain cells in every sheet need to be recorded in a different (summary)
sheet where i can ceate a list with the details of clients we quoted for -
say about 12 cells in every sheet need to be listed in columns.
Please help