+ Reply to Thread
Results 1 to 7 of 7

vba macro to generate statistics on employee biometric monthly attendance

  1. #1
    Registered User
    Join Date
    12-18-2018
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    14

    vba macro to generate statistics on employee biometric monthly attendance

    jpg of attendance sample is not getting attached.
    Status P A WO
    In Time 8:56 9:03
    Out Time 16:32
    Early By
    LateBy
    OT

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: vba macro to generate statistics on employee biometric monthly attendance

    Hello,
    You could add the excel file as attachment in "Go Advanced -> Manage attachments"
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    12-18-2018
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    14

    Re: vba macro to generate statistics on employee biometric monthly attendance

    i have attached excel sample
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: vba macro to generate statistics on employee biometric monthly attendance

    The attached file shows i think only one employee.
    Do you wanted to have for only one employee or for many?
    if for many then i need samples for them as well.

  5. #5
    Registered User
    Join Date
    12-18-2018
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    14

    Re: vba macro to generate statistics on employee biometric monthly attendance

    The excel file contains nearly 100s of employees attendance. So i want the macro to work on dynamic range.
    Please give some intro of how to go about

  6. #6
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: vba macro to generate statistics on employee biometric monthly attendance

    Is this format the excel will be?
    Row 1 - Day? is yes then why only 10 days?

    can you add two more employee details as well, to see how the data will be & how to consolidate it as well
    m01.PNG

  7. #7
    Registered User
    Join Date
    12-18-2018
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    14

    Re: vba macro to generate statistics on employee biometric monthly attendance

    yes.
    img file is only 4mb, still i am not able to attach. I can forward it to email if provided.
    The biometric software is not giving report as preferred, so we want to export the report to excel
    for further refinement. The data has in between rows with employee name and other details. So data
    ranges are not consecutive. Further no. of columnsi,e days in month varies. I would like to point at rows
    of particular employee and call the suitable macros.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Biometric Attendance record data Summary
    By sadiqchamdia in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-29-2018, 07:46 AM
  2. Biometric Timings to Attendance Calculation with conditions using Excel VBA - Reg.
    By perpectuals in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2017, 09:57 AM
  3. Biometric Timings to Attendance Calculation with conditions using Excel VBA - Reg.
    By perpectuals in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2017, 05:59 AM
  4. Biometric Timings to Attendance Calculation with conditions using Excel VBA - Reg.
    By perpectuals in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2017, 05:58 AM
  5. Employee Vacation and Attendance Tracker-VBA Macro
    By emmyem21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2015, 10:20 AM
  6. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  7. Macro? To help generate a student attendance list......
    By LMM21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 05:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1