Copying data from a certain sheet to another sheet for attendance in VB

i really need your help on this one guys..

please help me on this

please please help me. i need this for my job

Thank you so much watersev! Is the code applicable to more dates for example if the date is from May 1-15 or from May 16-30?

as per your sample file template to be filled in ends on row 30 (19 rows of data per employee) so that is the limitation for now

if you want template to allow more data rows:
1. Amend template sheet
2. Amend code line (2 instances):

Please Login or Register  to view this content.

where i30 - last data row for now. Change it to new reference, ex. i100

i tried the code on this file but i get an error that subscription is out of range.. sheetsample2.xlsx

have you noticed that your sample file data structure differs from the real one - it has empty rows between each employee. What is the point to make it different from the sample file you post?

Please check attachment

Thank you so much. It works. Can the data on the column ATT_time be extracted also on the template? It will be placed on the column Time Worked. Attach is the excel file containing the new template.. sheetsample2(1).xlsm

please check attachment

Sorry for the late reply.. I will try now the new file you attached.. I will give feedback later.. Thank you so much..

Hi watersev! It works. Can I request to add something in the code. If there's no log-out or log-in on the mainworksheet for every employee, is it possible to display no log-out or log-in on the table also and color it red just to identify?

Hi watersev! Would it be possible to convert the log-in and log-out extracted from the mainworksheet to a 12 hour clock? For example if its 21:05 at the main worksheet, it will become 9:05 pm on the table? Would that be alright?

1. If log-in time is present and log-out is absent, log-out becomes highlighted (row 117, Ella) and vice versa. Conditional format is used.
2. The format displayed on the sheet is AM/PM though values stay in 24H format, is that acceptable?

Thanks waterserv. It works. But for Time Worked column, there's no need for the 12 hr format.. The output should just be the same as what is found on the mainworksheet. I have also question, what if the employee's schedule is openshift, meaning there's no specific schedule for him. Can their log-in and log-out be plotted also?

Attach is the sample file for employees with openshift.. The macro for this can be different. openshift.xlsx

Re Time Worked column: change number format on Template sheet for this column and run code again

ok.. thanks.. i got it.. how about for the openshift schedule? would that be possible?

i do not see any explanation in the file provided or result sheet that should be obtained as a result

Here's what should be outcome.. If the employee's log in is from 4:00 am to 12 pm then it should go to the morning log in.. if the log in is from 12:01 pm to 6 pm, it will go to the afternoon log in.. if the log-in is from 6 pm to 3:59 am it will go to the evening log-in.. For the log-out, if the employee log out 4:00 am to 12 pm, it will go to morning log-out.. If the employee log-out from 12:01 pm to 6 pm, it will go to afternoon log-out and if the employee log-out from 6:01 pm to 3:59 am it will go to the evening log-out.. then the att_time column on the mainworksheet will be plotted also on the Time Worked column on the template.. no need to put no clock in or no clock out if clock in is not found or clock out is not found. hope you can help..

I hope after posting solution to your last question you would not ask me what whould be the code if shifts are mixed . If you are going to do that, tell it now

Hmm.. I',m so sorry didn't get what you mean.. but for this problem, you may have a separate macro for this.. because the macro for this one is exclusive only for those who have openshifts..

please check attachment, press Run on "idig open 16-30" sheet

Thank you so much watersev. I will try the file you attach later.. I will give feedback after trying it..

thank you so much watersev. i already tried the codes. it works perfectly.. thank you so much.. i will now close this thread..

hi watersev.. i hope you could help me on this new problem i posted.. here's the link of the thread http://www.excelforum.com/excel-prog...ch-in-vba.html