Hello All,
I have duty schedule for various Staffs on various Stores. All Sheets are of same pattern. I am enclosing a Sheet with my Problem only for one Store as a Sample. I have many sheets in the workbook (50+). Each Staff name appears in a Row. Sometimes two Staff Names are in a Row (See Row 59 in the sample attached). Staff Names will be varying for other Stores. At present I am using Index Function with Countif to count the Names of Staff. (Please see in the sample). As there are more than 50+ Sheet I have to do it on each sheet manually which is time consuming and also when more than one name comes on a Row my Countif gives wrong answer. I have color coded the Staff name Rows for sake of easy explanation of my problem. I need a macro which will run on all the Sheets in this Workbook and give me the Staff Names, their count, Sheet name and the Month Value from Cell of F4. See the desired output required in Range A70:D75. Any help would be greatly appreciated. TIA Rashid -- 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/groups/opt_out.
APR SCHEDULE - group.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
