Need Help

[Chris Watson]

I have been working on a Invoice worksheet for a local farmer, He stores
animals at a cost per day on his farm and bills the customer every
month. I have created the Invoice wooksheet and the formulas work fine
but I need to save the data entered onto a data sheet and also be able
clear the invoice for the next entry, also I would like to have a
invoice number that changes with every new invoice??????

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/sequentialnums.html

Save the workbook as a template. If you use one of the techniques in the
link above, it will generating a sheet from the template can give you
the new invoice number on a clear invoice.

Chris Watson