Hi Im new to VBA. I have a question below it would helpful if i got the answer
<tbody>
</tbody>
I have the above table for data.I want function/sub to search and get/return the value in Sub_Id and ID based on Department value.
The above table is example i have the sheet with 10000 rows
Thanks in advance
Department | Sub_ID | ID |
8585 | 00_A01 | 00_A |
9585 | 01_B20 | 01_B |
1010 | 00_C50 | 00_C |
2025 | 05_P20 | 05_P |
<tbody>
</tbody>
I have the above table for data.I want function/sub to search and get/return the value in Sub_Id and ID based on Department value.
The above table is example i have the sheet with 10000 rows
Thanks in advance