sequencing numbers

B

barb

I am trying to put in macro for my invoices that will sequence the next
number every time I open my invoice file that is saved in excel. Can someone
help me with the programming I am having no luck. Thanks
 
N

Nigel

For the range of invoice values use get the maximum value to get the highest
number and then add to that.

As the list grows you need to set the range that represents all of you
invoices. Use a dynamic range to do that.,
 
B

barb

I was at this site but it doesn;t seem to work for me when I try it on my
invoice. I downloaded a template invoice would that make a difference why I
can't add the macro?
 

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

Cumulative formula for word table 0
Table of content - format does not get saved 2
How can the font and size of (all) citation numbers be altered? 1
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Creating a Search using a combo box and then creating a report. 4
Finding the proper style field and the numbered paragraph value within the style 0
Working outlook via vba code with xlsx - error 0
Finding the right style field in VBA 0

Top