I am working with a Microsoft Excel spreadsheet and need some help with automating a filter based on a dropdown selection. Here’s the scenario:

I have a table called SchoolDatabase that includes the following columns:

• ID
• Name
• Age

In cell B2, I have a dropdown menu that allows users to select a student’s name. I want the table SchoolDatabase to automatically filter and display only the row corresponding to the selected student’s name from the dropdown in B2. Once filtered, I want to be able to edit the information in that row.

How can I achieve this in Excel?

Here are the details of my setup:

The table SchoolDatabase is on Sheet1, starting from cell A1.
The dropdown menu in B2 is also on Sheet1.

What I have tried:

I attempted to use the FILTER function, but I am unsure how to apply it in this context to filter the table based on the dropdown value. Additionally, I tried using VBA but couldn’t get it to work as expected.

Could someone provide a step-by-step guide or a sample VBA script to accomplish this task? Any help is appreciated!

Thank you!