Kumar Chandra
New Member
- Joined
- Jun 15, 2018
- Messages
- 13
Please help me below. Hope someone can help me,
I have two workbook like below:
Workbook 1 As below:
<colgroup><col width="72" style="width: 54pt;">
<col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5">
<col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 3584;">
<tbody>
</tbody>
Workbook 2 Dates are in DD format
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;">
<col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 928;" span="27">
<tbody>
</tbody>
I want result as below (AL= Annual Leave, SL = Sick Leave...)
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;">
<col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 928;" span="27">
<tbody>
</tbody>
Thank you
I have two workbook like below:
Workbook 1 As below:
S.No | Name | Leave Start | Leave End | Total Days | Leave Type | |
1 | AA | 01-Jan-17 | 04-Jan-17 | FALSE | 4 | Annual Leave |
2 | B | 08-Jan-17 | 11-Jan-17 | FALSE | 4 | Annual Leave |
3 | AA | 15-Jan-17 | 18-Jan-17 | FALSE | 4 | Sick Leave |
4 | AA | 21-Jan-17 | 22-Jan-17 | FALSE | 2 | Annual Leave |
5 | B | 28-Jan-17 | 05-Feb-17 | FALSE | 9 | Sick Leave |
Workbook 2 Dates are in DD format
Date 1-jan to 27 Jan | |||||||||||||||||||||||||||
Name | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |
AA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
I want result as below (AL= Annual Leave, SL = Sick Leave...)
Date | |||||||||||||||||||||||||||
Name | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |
AA | AL | AL | AL | AL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | SL | SL | SL | SL | 1 | 1 | AL | AL | 1 | 1 | 1 | 1 | 1 |
B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | AL | AL | AL | AL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Thank you