Your #22 Reply -- ? - it would be A+B / B + C Shift
My #23 Reply -- No answer? - this rule has been removed, pl ignore my previous rule, it is confusing me too thats why removed the rule.
There won't use P-word! maybe challenge! - i am not able to understand this, sorry
There are still HOLES! -...
My apologies for made you waiting, in fact, i was also confused with the timings of the shift initially and as you rightly pointed out in the earlier posts, I must be thankful to you. Finally, your questions really made me realize the mistake that i was doing so far when filling shifts manually...
I added the old sheet for your reference, which may not be much important to you. You may ignore it.
Frankly, the questions asked in the sheet was unable to figure out.
Could you send me collaboratively, pls.
Thank you.
I have attached xl workbook having two sheets. 1). 'Fresh Rules' sheet 2). Old sheet that you worked.
Pl look at 'Fresh Rules' Sheet in the attached to have full clarity on Shift rules, Worked hours rules and Standard timings.
And also the Sheet, 'Fresh Rules' contains some Comment boxes...
I am extremely sorry for the inconvenience caused you during my conversation.
After seeing your questions, above, I felt that I have been doing many mistakes in entering the Shifts Manually.
I will come out soon with pure examples to all your queries.
Attached file with my answers.
I saw the results of worked hours and shifts, its great to see row by row filling the data. I will confirm it soon the Shifts and its suitability by doing it manually.
Thank you for sparing your time.
I have give step by step procedure clearly in the attached.
Pl look at the steps, hope you get more clarity that what I am looking at.
Pl let me know any further info to share.
Thank you in advance.
I am extremely sorry for giving you trouble, I am not able to figure out the question that you are asking. And guessing the below answer that you seek from me.
Attached above dpt.xl file with 2 Sheets, Sheet 1 - Empty Shift column ; Sheet 2 - Sample format of the report with Shift.
Is that you...
As I understand the above question that you asked.
Those criteria mentioned above (5) are based on 2 columns (In Punch & Worked Hours) shown in the earlier attached xl.
Let me give you the process in detail;
For instance, if I fill want to fill the in Shift as 'A', I would look at first "In...
As I mentioned above, here is my other request for your support.
Attached & shown below computer/in-built software generated xl sheet, I would like to do the below.
Once I click the Button, VBA code would need to filter the 'Column - Shift' and select 'NoShift' rows and 'Weekly off' rows...
Excellently working which I needed exactly. Many thanks for your help.
I would need one more VBA solution which I am facing, would post you soon.
Once again my thanks.
Thank you so much for your reply. Exactly worked what I intended.
Just I need one more help from you, the rows selected based on the criteria are copying and pasting in other sheet perfectly. But I need, Cut and Paste the rows those selected, so that the first sheet should not having those...
Dear all,
Let me put my request little more clear.
I need the VBA code, if I click the button i would like to select the rows containing the values 'APCW2' (not exactly but only containing/starting with APCW2) in the column 'Emp Code' and cut and paste in the new sheet of the same workbook...