Hello,
We are working with a finger print clock in and out maching but sometimes employees forget to clock in or out.
I would like to create a macro to be able to fix it.
Hello,
We are working with a finger print clock in and out maching but sometimes employees forget to clock in or out.
I would like to create a macro to be able to fix it.
Hi, welcome to the forum, since it's your first post (at least here) I understand that you might think that a few words are sufficient for us to understand your entire issue.
I suggest you explain it in a way others that have no idea what you're trying to do can understand it too.
You know, guessing is not an option in these cases and time is valuable to many of us and not first need to figure out what an OP is asking and base answers on assumptions.
Maybe the file explains it, but the post doesn't, try again, please
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Paste code into a module.
Please Login or Register to view this content.
Hello Keebellah.
Im sorry. What I am trying to do is create a Macro to fix the timesheets, if you see the spreadsheet sometimes the employee forgot to press the right button (in or out) So it takes me time to fix the timesheet everytime they forget to clock in or our. Also when the press In instead of out. Or maybe have all the times below the date instead of the way it is right now
You've got torachan's macro, what more do you need?
BTW why are you using xls files?
I tried to do it but it did not work
Works for me, If I insert the macro and run it it marks those records with missing In and Missing OUT
Can you explain to me how to run a macro? I'm probably doing something wrong
Actually, It is possible to convert the spreadsheet to something like this? That way I can create a pivot
Attachment 706910
Would you please attach the file in the indicated manner?
I placed the macro in the file
Oh, thanks. That's exactly what I needed.
Also, do you know how can I add I default time in case the employees forget to clock in or out?
You code it in the macro, and you will have to figure out what the time is you want to enter.
Please Login or Register to view this content.
either will workPlease Login or Register to view this content.
How can you guys use power pivot and how to download it in Mac and PC Excel 2018
Hey Guys!
There is a possibility of sharing a Macro of my personal folder without sending my whole folder?
I don't understand your question.
But if it's just one macro form your VBAProject, you can select the text of that macro and place within code tags in your post
You're acquainted with the forum rules and it's explained if you read the banner.Please Login or Register to view this content.
If you want to export the entire module you can also do this but then attach the resulting bas file a s a zipped file because the bas extension is not recognized or accepted
Hope my explanation makes sense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks