dear experts,
i was thinking about an automatized timetable which could look like this
i insert the month/year in the first column and the related cell will be entered with whatever value 'x'
<tbody>
</tbody>
since INDEX(MATCH) is somehow the reversed function i guess this should be possible.
i just have no idea how to write the vba code.
do you have some help/suggestions
thanks in advance !
i was thinking about an automatized timetable which could look like this
i insert the month/year in the first column and the related cell will be entered with whatever value 'x'
insert month here | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 |
01 | 'x' | |||||||||||
08 | 'x' |
<tbody>
</tbody>
since INDEX(MATCH) is somehow the reversed function i guess this should be possible.
i just have no idea how to write the vba code.
do you have some help/suggestions
thanks in advance !