Hello Every One I am Trying from several days a Function to make to manage my work. But not able to succeed. If anybody have some time please look and help.
My excel having 32 worksheet 1 Sheet Contains the summary & rest is date wise for whole month. I need to search the whole workbook to count the work done by employee for each assignments. I am unable to compile the data as every sheet has more than 1200 entries. So need a function which call on first sheet and count the work done by each employee.
This is how every sheet have data:
<tbody>
</tbody>
On first sheet we have Summary/Output
<tbody>
</tbody>
Please Note: The function only count from 1 to 31 and other sheet data should not be counted as to get the right results. Or any other you can suggest to get exact result.
My excel having 32 worksheet 1 Sheet Contains the summary & rest is date wise for whole month. I need to search the whole workbook to count the work done by employee for each assignments. I am unable to compile the data as every sheet has more than 1200 entries. So need a function which call on first sheet and count the work done by each employee.
This is how every sheet have data:
Delay | Jane |
Cancellation | Ravi |
Delay | Jane |
<tbody>
</tbody>
On first sheet we have Summary/Output
Employee Name | Delay | Cancellation |
Jane | 2 | 0 |
Ravi | 0 | 1 |
<tbody>
</tbody>
Please Note: The function only count from 1 to 31 and other sheet data should not be counted as to get the right results. Or any other you can suggest to get exact result.