Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sequntial counter

Posted on 2011-03-10
1
Medium Priority
?
384 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 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

596 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