• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Preparation of Monthly Attendance Report

V

VDS

Member
Dear All,
I attach herewith a sample file contains two worksheets. It is the attendance of various employees for a particular month

Worksheet named “ALL DATA” contains list of employees, I have taken the value from Column B and extracted to respective columns of Date, Time, Name of Person, Card No, mode (Entry/Exit).

The worksheet “Monthly Report”, is the format in which data is to be generated. I tried Index and Match functions.

How to fill up the INTIME and OUTTIME of each employees against the dates with any functions say from 1st to 30th of each month.

Dates in the Monthly report worksheet has been extracted with TRNSPOSE. But when I try to delete the columns, it displays. “You cannot change part of an array.” Why this happens ?

Your help is requested

It would be more convenient without any macro.

VDS
 

Attachments

  • Data.xls
    60 KB · Views: 15
Hi VDS,

Good to see your query after a long time. See the file, I had added Sheet2, with new extracted values. Than I had created Pivot table to get the summary on Sheet3.

Now you cannot delete the date in your Monthly report sheet as the TRANSPOSE function is entered as an array to get the values of array in different cell. And Excel don't allow to alter a part of an array.

Regards,
 

Attachments

  • Data (1).xls
    67 KB · Views: 16
@Asheesh

There is no limitation here to answer any query, If you develop some solution you can post. Many a time we get solution to a SOLVED query after many days, and many of the time those solutions are better than the earlier posted one.

So enjoy learning :)

Regards,
 
You must log in or register to reply here.
Back
Top