• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Sequntial counter

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
BioSante
Asked:
BioSante
1 Solution
 
donaldmaloneyCommented:
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] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now