Appendix-Thread-Evaluate-Range-(-Codes-for-other-Threads-HTML-Tables-etc-)

[DocAElstein]

Some extra notes in support of this Thread post
https://excelfox.com/forum/showthrea...ll=1#post19860

I am using Match in two few places, and that is the main workings of the macro
Rem 1 - one gets the row number need for the output
Rem 2 – the other gets the column needed for the output

This is the test data given:





This is the requirement

.....
- the value from H2 cell (Database) to be added in D2 cell (Database1) because the name is John, the Activity is A.1, Sub-activity is A.1.1 and the Month is November 2022 (with yellow)
- the value from H5 cell (Database) to be added in G20 cell (Database1) because the name is Anne, the Activity is A.2, Sub-activity is A.2.1 and the Month is February 2023 (with gray)
.......and so on

Next post, some further explanations , in particular about what the Match bits are about