In support of this forum post
https://excelfox.com/forum/showthrea...ll=1#post16376







After





_____ Workbook: Work_file.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
1
 Name Project Task
01-22
02-22
03-22
04-22
2
 aaa Project1 Task1
3
 aaa Project1 Task2
4
 aaa Project2 Task1
5
 aaa Project2 Task2
6
 aaa Project3 Task1
7
 aaa Project3 Task2
500
8
 aaa Project4 Task1
9
 aaa Project4 Task2
10
 aaa Project5 Task1
11
 aaa Project5 Task2
12
 bbb Project1 Task1
13
 bbb Project1 Task2
14
 bbb Project2 Task1
15
 bbb Project2 Task2
100
16
 bbb Project3 Task1
17
 bbb Project3 Task2
18
 bbb Project4 Task1
19
 bbb Project4 Task2
20
 bbb Project5 Task1
21
 bbb Project5 Task2
22
 ccc Project1 Task1
23
 ccc Project1 Task2
24
 ccc Project2 Task1
25
 ccc Project2 Task2
26
 ccc Project3 Task1
27
 ccc Project3 Task2
28
 ccc Project4 Task1
29
 ccc Project4 Task2
30
 ccc Project5 Task1
200
31
 ccc Project5 Task2
32
 ddd Project1 Task1
Worksheet: Database1