Thread Killer Mk X

Status
Not open for further replies.
I think it's the best gif I've ever come across because it's creepy but in a way that makes your brain think "I dunno why the fuck that is creepy!"
 
matt said:
Here you go

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Cells(Target.Row, Target.Column + 1).Value = Now()
End If
End Sub
Click to expand...

matt said:
In fact, here, download this. You'll need to click the button to enable content, since it works with VBA script, and that'll be after the button to enable editing (because it's a download)

https://www.dropbox.com/s/58ek7c35g8wb6yw/Barcodes.xlsm

EDIT: Added a line to delete the date/time if you delete the barcode as well
Click to expand...

Shot man !
 
matt said:
Here you go

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Cells(Target.Row, Target.Column + 1).Value = Now()
End If
End Sub
Click to expand...

matt said:
In fact, here, download this. You'll need to click the button to enable content, since it works with VBA script, and that'll be after the button to enable editing (because it's a download)

https://www.dropbox.com/s/58ek7c35g8wb6yw/Barcodes.xlsm

EDIT: Added a line to delete the date/time if you delete the barcode as well
Click to expand...

matt said:
Sure, let me know if it works for you
Click to expand...

dddddd.jpg

Ok it works - now say that particular persons OUT times need to be recorded as well - any way to make it a Time in and Time out next to each other?
Don't underestimate how kak I am with codes.
 
Murph said:
View attachment 11309

Ok it works - now say that particular persons OUT times need to be recorded as well - any way to make it a Time in and Time out next to each other?
Don't underestimate how kak I am with codes.
Click to expand...

I'm sure. How would we know if it's in or out though?

I could make an In column, and an out column, and a date/time for each.

Or have an in worksheet, and an out worksheet?
 
Mephisto_Helix said:
jirre fok all this code kak .......... work less fuckers
Click to expand...

This is work - and I'm fcking stuck. God knows why I got saddled with this.

matt said:
I'm sure. How would we know if it's in or out though?

I could make an In column, and an out column, and a date/time for each.

Or have an in worksheet, and an out worksheet?
Click to expand...

See what you mean - IN would be early morning and out be later or greater than say 14:00 or whatever. Depends on when the activity ends of course - but I suppose I could just have a line running down and then filter per department.
 
Murph said:
This is work - and I'm fcking stuck. God knows why I got saddled with this.



See what you mean - IN would be early morning and out be later or greater than say 14:00 or whatever. Depends on when the activity ends of course - but I suppose I could just have a line running down and then filter per department.
Click to expand...

If it's just before or after 14:00, then you can put another formula in next to the time that outputs In or Out.

Otherwise, you could potentially get quite fancy and make a screen where you select In or Out and department, and then scan a barcode, and it adds the details to another sheet....
 
Status
Not open for further replies.
Back
Top