Tech Support Guy banner

Testing Excel Question, May not be Possible

915 Views 1 Reply 2 Participants Last post by  Anne Troy
Ok. Using Excel. What i am looking for is on opening a worksheet and pressing a button to maybe activate a Macro, this sould result in the autonumbering of that worksheet. i.e. On opening a worksheet to input a new clients details, a number will be automatically displayed on that sheet (Next in a string i.e 1,2,3 etc) and that number will be specific to that job.
It's hard to expalian but basically i need an auto numbering of the worksheet when i start a new one.
As clear as mud im sure.

Not open for further replies.
1 - 2 of 2 Posts
The mud is not so bad as you might think. I believe I understand what you want.

Please go download this freebie under the Excel section of the page:



It generates a new number each time you open it. You can steal the VBA out of it.

If you don't know VBA well enough, then I suggest you ask your question at

See less See more
1 - 2 of 2 Posts
Not open for further replies.