Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Track Changes - User / Time / Date
We have a spreadsheet that is shared between several users. It is used to
track specific calls that come in. Every time a call comes in, the user goes into the spreadsheet and enters on the next available line some of the customer information (i.e. name, address, issue, etc). I would like to have it that every time the user starts a new entry on a line, that the Username, Time, Date of the change automatically appear in the first few columns, respectively, of the new row. I started to make a formula where the user just enters the date and then I had a "Now" formula that would automatically enter the time, but obviously, that "Now" time would change every time the workbook is opened. Any ideas? I have a feeling this will be more of a programming issue (which is fine), just hoping for something to make this spreadsheet more fool-proof. Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Track Changes - User / Time / Date
Hi,
You will need to use VBA. Here is some sample code: Private Sub Worksheet_Change(ByVal Target As Range) Dim isect As Range Set isect = Application.Intersect(Target, Range("A1:A100")) If Not isect Is Nothing Then Cells(Target.Row, 2) = Date Cells(Target.Row, 3) = Time Cells(Target.Row, 4) = Application.UserName End If End Sub 1. To add this code to your file, press Alt+F11, 2. In the VBAProject window, top left side, find your sheet name under your file name and double click it. 3. Paste in or type the code above. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Keep It Simple Stupid" wrote: We have a spreadsheet that is shared between several users. It is used to track specific calls that come in. Every time a call comes in, the user goes into the spreadsheet and enters on the next available line some of the customer information (i.e. name, address, issue, etc). I would like to have it that every time the user starts a new entry on a line, that the Username, Time, Date of the change automatically appear in the first few columns, respectively, of the new row. I started to make a formula where the user just enters the date and then I had a "Now" formula that would automatically enter the time, but obviously, that "Now" time would change every time the workbook is opened. Any ideas? I have a feeling this will be more of a programming issue (which is fine), just hoping for something to make this spreadsheet more fool-proof. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User name , date and time | Excel Discussion (Misc queries) | |||
how to track the number of user accessing an .xls file | Excel Worksheet Functions | |||
Showing "Created by User, Date, Time" in Footer | Excel Discussion (Misc queries) | |||
Track time | Excel Worksheet Functions | |||
Macro to record user name and date/time | Excel Discussion (Misc queries) |