how can i get excel to sequentially add numbers to new worksheets?

G

Guest

Working with an invoice type setup, I need excel to look to the previous
sheet and add 1 to it creating the next invoice number in line. So that when
I create a new sheet it will automatically create the next available number
without having to go and manually enter the reference sheet each time. Is
this an array function? Can anyone give direction as to the number system I'm
looking for?
 

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

Function for counting Worksheets? 2
auto add data with addition of new worksheets 5
Invoice Numbers 1
How do I sequentially number indvidual worksheets? 2
how to give an automatic number 1
HOW DO I DUPLICATE SHEET TO BOOK??? 2
Losing rows that reference data from another worsheet 1
How can I create a running yearly total for all of my invoices? 1

Top