I need help w Excel VBA. Im trying to write a code that matches the chemical name found on a drop down $($in this case C$3)$ to the table right below it $($column B$)$ and hides the rest of chemical $($in this case chemical B was picked, i want the code to hide every other chemical except B which includes $3$ rows $($i$.,$ii$.,$and iii.$)$ as shown on the table next to it$).$ I attempted to write the code for it but it didnt work. I need help fixing it or writing a new one. thanks in advance. will uprate if its correct and works thanks