Hi all, i would like to support me so that to create a vba code, which should run through col. "C" and complete the missing dates by inserting a new row. Please note that the code should complete based on month's days. e.g. 30 or 31 or 28 The employees are 200+ and for each one i would like to complete the missing dates. below is an extract of the original data. Many thanks in advance.
<tbody>
</tbody>
A | B | C | |
1 | I.D. | Name | Date |
2 | 1555 | EMPL. 1555 | 01-12-17 |
3 | 1555 | EMPL. 1555 | 04-12-17 |
4 | 1555 | EMPL. 1555 | 05-12-17 |
5 | 1555 | EMPL. 1555 | 06-12-17 |
6 | 1555 | EMPL. 1555 | 07-12-17 |
7 | 1555 | EMPL. 1555 | 08-12-17 |
8 | 1555 | EMPL. 1555 | 11-12-17 |
9 | 1555 | EMPL. 1555 | 12-12-17 |
10 | 1555 | EMPL. 1555 | 13-12-17 |
11 | 1555 | EMPL. 1555 | 14-12-17 |
12 | 1555 | EMPL. 1555 | 15-12-17 |
13 | 1555 | EMPL. 1555 | 18-12-17 |
14 | 1555 | EMPL. 1555 | 19-12-17 |
15 | 1555 | EMPL. 1555 | 20-12-17 |
16 | 1555 | EMPL. 1555 | 21-12-17 |
17 | 1555 | EMPL. 1555 | 22-12-17 |
18 | 1555 | EMPL. 1555 | 27-12-17 |
19 | 1555 | EMPL. 1555 | 28-12-17 |
20 | 1555 | EMPL. 1555 | 29-12-17 |
21 | 1555 Count | ||
22 | 1555 Total | ||
23 | |||
24 | 1578 | EMPL. 1578 | 01-12-17 |
25 | 1578 | EMPL. 1578 | 04-12-17 |
26 | 1578 | EMPL. 1578 | 05-12-17 |
27 | 1578 | EMPL. 1578 | 06-12-17 |
28 | 1578 | EMPL. 1578 | 07-12-17 |
29 | 1578 | EMPL. 1578 | 08-12-17 |
30 | 1578 | EMPL. 1578 | 11-12-17 |
31 | 1578 | EMPL. 1578 | 12-12-17 |
32 | 1578 | EMPL. 1578 | 13-12-17 |
33 | 1578 | EMPL. 1578 | 14-12-17 |
34 | 1578 | EMPL. 1578 | 15-12-17 |
35 | 1578 | EMPL. 1578 | 18-12-17 |
36 | 1578 | EMPL. 1578 | 19-12-17 |
37 | 1578 | EMPL. 1578 | 20-12-17 |
38 | 1578 | EMPL. 1578 | 21-12-17 |
39 | 1578 | EMPL. 1578 | 22-12-17 |
40 | 1578 | EMPL. 1578 | 27-12-17 |
41 | 1578 | EMPL. 1578 | 28-12-17 |
42 | 1578 | EMPL. 1578 | 29-12-17 |
43 | 1578 Count | ||
44 | 1578 Total | ||
45 |
<tbody>
</tbody>