Hello,
My question is about Drop-Down table lists and how to get the index of that specific selected item from the Drop-Down list so I can access the other columns info from that row index.
I have a macro-based excel workbook that has two worksheets ("Pointage" and "Employeur").
The "Pointage" sheet has drop-down list from sheet "Employeur".
If the user selects an item from the drop-down list, I want to gets its original row index from the "Employeur" sheet so I can get infor mation from the next columns based on that row index.
The attached screenshots illustrates a little bit what I need to achieve.


Thank you for your understanding.
My question is about Drop-Down table lists and how to get the index of that specific selected item from the Drop-Down list so I can access the other columns info from that row index.
I have a macro-based excel workbook that has two worksheets ("Pointage" and "Employeur").
The "Pointage" sheet has drop-down list from sheet "Employeur".
If the user selects an item from the drop-down list, I want to gets its original row index from the "Employeur" sheet so I can get infor mation from the next columns based on that row index.
The attached screenshots illustrates a little bit what I need to achieve.


Thank you for your understanding.