+ Reply to Thread
Results 1 to 1 of 1

Excel not capturing the system user name, Start time, end time and total time spent

  1. #1
    Registered User
    Join Date
    03-17-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    62

    Excel not capturing the system user name, Start time, end time and total time spent

    Hi All,

    I have a macro enabled excel sheet. Let me explain how it works. Column E has data. If an user click a cell, automatically the data in a specific cell would go away and it would turn to red color. The same value would pop-up in H column. This is like a pick option tool. Whoever finishes it faster, they can go ahead and click another case and continue to work on.

    Now I would like to bring in a small change in this sheet. I am going to make this as a shared sheet since 9 other people would be working on this sheet. Column F should pop-up the system user name, so I can identify who has picked a specific case. Also, this sheet should automatically get saved for each xx micro seconds as the more fast the sheet gets saved the better next person would come to know about the changes (to avoid duplication).

    Also, when we scroll down the headers like "Ref#, Associate Name (system user name - column F and Your selection column H) shold not scroll up. It should be stable like freeze. only datas should scroll down. On a daily basis I would have data for nearly 300 lines. So, E2 to E502 would be having the data.

    Kindly help me in getting this solved. Along with this, if you find anything useful which could be built-in like start time and end time, it could be very helpful for me. Column I - Start time, Column J End time and column K total time spent.

    Thanks for all your help in advance!!.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tracking Time Spent on System
    By sr2701 in forum Excel General
    Replies: 2
    Last Post: 04-26-2015, 11:51 AM
  2. Replies: 9
    Last Post: 02-15-2015, 07:32 PM
  3. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  4. Capturing Ideal system time using excel VBA
    By Seno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2013, 11:36 PM
  5. Automatic generation of Start time, end time and total time in excel
    By dreamwarden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 08:03 PM
  6. Ready Time, Start Time, Finish Time by user
    By teguigala in forum Excel General
    Replies: 3
    Last Post: 02-15-2012, 03:34 PM
  7. [SOLVED] template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 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