marc651
03-09-2020, 08:09 AM
Hello,
I have 3 documents. 2 of them I use to get avalabilty information from teachers. Document B2 is sent to teachers so they can fill in their avalabilty. When I press the button, it matches the teachercode in document B1 and transfers the green and red cells.
That works fine. Now I want to gather some more infomation. In document B3, I added 2 more rows. In cell C22 they have to fill in the course that they teach. And incell C3 they have to fill in their workpercentage, '1.0'= 4 hours, '0.8' 3 hours, etc. Then match, and transfer to document B1.
What I can't get done is to get the value of cell C22 in Column B with the matching teachercode, and the value of cel C23 in column C with the matcing teachercode.
The rest should do te same as it is now. Can somebody help me?
I have 3 documents. 2 of them I use to get avalabilty information from teachers. Document B2 is sent to teachers so they can fill in their avalabilty. When I press the button, it matches the teachercode in document B1 and transfers the green and red cells.
That works fine. Now I want to gather some more infomation. In document B3, I added 2 more rows. In cell C22 they have to fill in the course that they teach. And incell C3 they have to fill in their workpercentage, '1.0'= 4 hours, '0.8' 3 hours, etc. Then match, and transfer to document B1.
What I can't get done is to get the value of cell C22 in Column B with the matching teachercode, and the value of cel C23 in column C with the matcing teachercode.
The rest should do te same as it is now. Can somebody help me?