I've looked around these forums and done some searching on Google but didn't find exactly what i was looking for so i hope you guys can help me out!
Ok, So i have an excel sheet in which i need to do the following:
I have a dropdown menu with some 300 values in cell A1 from which users can select a value. (e.g. "Test" "Test2" "Test3" etc.)
There are 5040 rows in the sheet and the value chosen from the dropdown menu can occur in 6 cells per row. (Columns K to P)
I need a macro that will check these 6 cells per Row for the value chosen from the dropdown menu in A1.
If any of these 6 cells per row doesn't contain the value selected from the dropdown menu in A1 i want to hide the row that doesn't contain that value.
Then i would also like to have a "reset" button in A2 which you can press to unhide the rows again.
I really hope you guys can help me out.
Thanks,
Bas
Ok, So i have an excel sheet in which i need to do the following:
I have a dropdown menu with some 300 values in cell A1 from which users can select a value. (e.g. "Test" "Test2" "Test3" etc.)
There are 5040 rows in the sheet and the value chosen from the dropdown menu can occur in 6 cells per row. (Columns K to P)
I need a macro that will check these 6 cells per Row for the value chosen from the dropdown menu in A1.
If any of these 6 cells per row doesn't contain the value selected from the dropdown menu in A1 i want to hide the row that doesn't contain that value.
Then i would also like to have a "reset" button in A2 which you can press to unhide the rows again.
I really hope you guys can help me out.
Thanks,
Bas