Results 1 to 23 of 23

Resetting data

Threaded View

  1. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Resetting data

    Exact method will depend on workbook structure and what record you will keep, how often vouchers are issued by each user etc.

    But, I'd likely keep a table in hidden sheet, where user name and voucher count is tracked and incremented.

    For an example use Environ("UserName") to verify who's logged in and issuing voucher. And increment corresponding value.

    Edit: I'd also add Event code on Workbook_BeforeClose to auto save workbook. Or add code to save when voucher is issued.
    Last edited by CK76; 02-15-2018 at 12:26 PM. Reason: See Edit:

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Border resetting after data added to last row
    By drgkt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2017, 07:04 PM
  2. Resetting data to zero when a specific date is reached
    By Berean50 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2014, 11:34 PM
  3. Resetting a count to zero when entering a specified item in a data range
    By Kerr01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2014, 04:48 AM
  4. [SOLVED] Excel 2007 : Resetting Data Validation
    By Daniel Brown in forum Excel General
    Replies: 2
    Last Post: 05-26-2012, 05:23 AM
  5. Resetting/clearing a data validation
    By nalgene5622 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2012, 10:19 PM
  6. Resetting CutCopyMode
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2009, 08:28 PM
  7. Resetting Spreadsheet Data Entry Cells
    By acg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2007, 02:08 PM

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