Solved

Sequntial counter

Posted on 2011-03-10
1
318 Views
Last Modified: 2012-06-21
I would like to add a counter to a cell in a spreadsheet.  We have a master spreadsheet that we open enter data into then save under another name, then someone will open the master sheet again enter new data and save under a different name, etc.  I would like the sheet to get a unique sequntial identifier each time they enter new data.  I've tried a simple counter however the value resets each time I run the code.
0
Comment
Question by:BioSante
1 Comment
 
LVL 11

Accepted Solution

by:
donaldmaloney earned 125 total points
ID: 35099722
Set the name of the counter to say  " incCounter"

In Macros for the workbook add this function and each tiome the workbook opens the counter will be incremented
Private Sub Workbook_Open()
Cells.Range("incCounter") = Cells.Range("incCounter") + 1
End Sub
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
GFI and SCCM 2012 5 70
HxTsr.exe consuming resources 2 344
"This column type cannot be filtered" - Sharepoint 2010 3 74
Microsoft Access 2010 Question 2 63
I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now