Dear community members,
I'm new to VBA and would like to try something in one of my excel files. I would like to have a worksheet that based on a drop down list selection only keeps the rows which are referring to this selection.
For Example:
If D4 "LOG" is selected all rows which not contain "LOG" in column "A" should be deleted.
In this case the rows 120 - 142 would have been deleted (if Range is starting from "A74").
Do you have a good idea for a code?
Thank you very much!
I'm new to VBA and would like to try something in one of my excel files. I would like to have a worksheet that based on a drop down list selection only keeps the rows which are referring to this selection.
For Example:
If D4 "LOG" is selected all rows which not contain "LOG" in column "A" should be deleted.
In this case the rows 120 - 142 would have been deleted (if Range is starting from "A74").
Do you have a good idea for a code?
Thank you very much!