Solved

Sequntial counter

Posted on 2011-03-10
1
364 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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…
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…

696 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