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





_____ Workbook: Work_file.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I
1 S.No. Year Month Name Project Task Amount Submitted By
2
1
2022
 January bbb Project2 Task2
100
 Liviu Popescu
3
2
2022
 February ccc Project5 Task1
200
 Liviu Popescu
4
3
2022
 March aaa Project3 Task2
500
 Liviu Popescu
5
Worksheet: Database



_____ 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
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
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
31 ccc Project5 Task2
32 ddd Project1 Task1
33 ddd Project1 Task2
Worksheet: Database1