Time & Attendance Excel Worksheet

[recharger]

Hi There


We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched
https://www.excelforum.com/attachment.php?attachmentid=607220&stc=1&d=1548060569


Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and Checkout
Check In - meaning when the user start work
Breaks - Off duty for tea or lunch breaks
Check out- Meaning when user finishes work


Now what I want, a VB marco script on the attachment below:
https://www.excelforum.com/attachment.php?attachmentid=607221&stc=1&d=1548060784


On the worksheet open, to prompt me, to upload the Standard_report (from the device excel worksheet)
Refer to: Att.log report TAB
Create each new tab with the Employee Number
And fill in the working times (as shown in example for Employee 7 and 23)


Thats it


Could you kindly do this formula VB scrip

 

[Fluff]

Hi & welcome to MrExcel.
Cross posted https://www.excelforum.com/excel-pr...d-attendance-excel-worksheet.html#post5048119

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Also members here will not be able to download the files you have linked to, unless they are a member of ExcelForum as well.