New Invoice

  • Thread starter Thread starter excel help
  • Start date Start date
E

excel help

How can I setup a control or whatever is needed to ensure that each time I
click on a control button named Invoice that it brings up a fresh invoice
with a new invoice number and when closing it saves that invoice to a named
folder location allowing next invoice to start,

hope this is clear enough,

Leonard
 
Hi Leonard

for help on incrementing invoice numbers check out
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

if you'ld like a sample workbook that shows an incremental invoicing system
with a summary sheet and different pivot tables & reports that you might be
able to get some ideas from or customise for your own use email me direct at
julied_ng at hcts dot net dot au.

Cheers
JulieD
 
Julie - I have tried emailing you offline the group but to no avail - Can
you mail me at (e-mail address removed)

as soon as possible please,

Leonard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
template creates invoice - how to create summary worksheet? 13
How to gernerate invoice numbers in EXCEL? 2
invoicing 2
Create an Invoice from a row of data 2
Auto Number 1
Search and Replace, or Add New Row 1
Cumulatively list data from each new worksheet 1

Back
Top