Solved

Sequntial counter

Posted on 2011-03-10
1
303 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

747 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

12 Experts available now in Live!

Get 1:1 Help Now