Duplicate sheet, autonumber sheet, record data on another sheet
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
|