+ Reply to Thread
Results 1 to 2 of 2

Rev. Auto Updated when sheet is updated and or entire book

  1. #1
    Registered User
    Join Date
    11-08-2007
    Posts
    18

    Rev. Auto Updated when sheet is updated and or entire book

    Hello World,

    Looking for some help on the following.

    Everytime I make a change in a spread sheet and or any part of a book. Is there a way to autoupdate some type of Revision number.

    Example:
    If I edit a sheet when I save it I would like for the revision to look something like: 040608-1150am
    or
    040608a
    next 040608b

    How can I create with your help...this field somewhere on my book.

    Many copies flotting around...I people keep picking up the old information.

    thanks for all of your help in advance.

    Frank.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Okay, sounds like what you want is a particular cell to increase by 1 every time the workbook is saved. Would that work for you? Theoretically, people won't save the workbook unless they've made changes. This would require VBA but shouldn't be too difficult.

    ChemistB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1