Did this helped? On Jul 29, 2014 4:02 PM, "Vaibhav Joshi" <v...@vabs.in> wrote:
> Ok, Simple! > > You can use 3D formual to sum all 35 sheets particular cell in to yours > All data sheet. Need to ensure that there are all one after another.Check > cell b4 of all data sheet. > > for leave formula check Emp5 sheet row 51 i have applied formula. > > Cheers!! > > > On Tue, Jul 29, 2014 at 1:47 PM, ab12tatre <ab12ta...@gmail.com> wrote: > >> Uploaded the sheet in which i want to display the data. >> >> On Tuesday, July 29, 2014 11:35:08 AM UTC+5:30, ab12tatre wrote: >>> >>> Dear All, >>> >>> Hi! I'm trying to develop a worksheet to track the record of individual >>> employees reg. the work done by them. Pls have a look over the attachment. >>> >>> Here in the sheet all the core and non core tasks have been updated and >>> it works fine. Now in the sheet named as "All Data" I want to extract the >>> data of all the employees for the respective date. This will show the total >>> time of all employees for the particular day. I'm not sure about how to do >>> that. >>> >>> Also i'm facing problem in framing the code for the leaves taken and the >>> OT done. >>> We have 11 categories of leaves. The nested if stmt has a limitation of >>> 7 times only. >>> CLH,OLH,SLH,LOPH signifies half day leave and rest as 1 day. So i want >>> to show the no of leaves taken on particular day. We will be maintaining >>> this record for every day for 35 employees. >>> Don't know how to do that. I request you to kindly help me in completing >>> the task. >>> >>> The "All Data" sheet is same as other sheets. The only difference is >>> it'll have the sum of all employees work. >>> Pls add some random values, if required. Total working minutes per day >>> is 495. >>> I dont know how to show the sum of all sheets. So i've kept it as blank. >>> >>> Thanks, >>> Abhilash >>> >>> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
