is it possible to have multiple seperate timestamps per worksheet?

**hdogg86** · 04-16-2013, 11:04 AM

Backstory:
I have a spreadsheet with inventories for 6 different toolboxes itemized by quantity and serial number. The tools get taken out and brought back with varying degrees of completion, but are inventoried on departure and return. My boss would like to know when each specific box had its last inventory done and I suppose entering each timestamp manually would be easier but I am not the only person changing the values.

Problem:
Using what I have picked up from google, I learned to timestamp a cell based on the entire worksheet being saved or changed, but I am asking that a specific row (44) be changed when values in the corresponding column (B through O) is changed or new data is entered. The data in each column is only in rows 3-40... if that helps.

Current Progress:
My attempt at compiling a macro to meet my needs after several copy and paste and edit jobs has left me trying to patch together this code after trying to understand what works and what doesn't from several trials, errors and examples:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim c As Range
    Application.EnableEvents = False
    For Each c In Target
        If c.Column > 1 And c.Column < 20 Then
            Cells(44, c.Column) = Now
        End If
    Next c
    Application.EnableEvents = True
End Sub

If the macro I am attempting is not possible please let me know why. A possible workaround i have thought of is using multiple macros, one for each column, however i have not been able to work that properly. I am also looking into using helper cells if needed. Thank you for your forums insight into my problem thus far, the knowledge here has helped me in the past without my need to step any further past searches. And thank you in advance for any time you take replying to my post and/or helping with my work.

**scott.s.fower** · 04-16-2013, 03:33 PM

what about having a button for Check-in and a button for Check-out that will do the time stamp? you could set up the buttons to stamp the active cell or something. You could even have a popup that asks for initials so you would know who initiated the timestamp in case something's missing. I'm not quite sure how to exactly implement what you're asking without seeing how you use your workbook

**hdogg86** · 04-18-2013, 05:16 AM

The check in check out button seems like a viable option, but still too manual for my tastes since it is still possible for people to edit the quantities and/or serial numbers without the courtesy of marking when they fixed it. Most of the users of this worksheet will not be inclined to use such courtesy.

there are 9 active columns which i would like to have monitored by timestamp in row 44.

I have attached an example...

-----------------edit 19Apr2013-------------------

Hello again excel forum,

I have been looking around to solve my issue, but to avoid cross posting I have edited my initial response to see if I am on the right track... I think this is the type of timestamp i am looking for except i have my spreadsheet oriented where the timestamps have to be in the same column at row 44. Is it possible to edit the code to say something like this perhaps:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B3:B40")) Is Nothing Then
Target.Cell(44, 1).Value = Now()
End If
End Sub

Also, if i copy paste this code say, 6 more times will it result in 6 independent timestamps? I have been toying with this code to no avail, but hopefully I am on the right track to a solution. I would feel a little wierd if i were asking for help and not also trying to find a solution myself... but I don't want to undermine any efforts given by the experts at this forum. Thank you for all your efforts!