Forum Discussion
Solved
Excel filter and hide other columns
Hi all, I am curently working on a general table for our company. I've made a table for our partners. In the table they see some tasks, they all have responsibilities for different tasks, and th...
I have attached a small demo workbook. You'll have to modify the code for your situation.
To view the code, right-click the sheet tab and select 'View Code'.
You'll need to allow macros when you open the workbook.
Thanks!
One more question.
The cells with te partners refer to another sheet (main sheet). With data valadition there is no problem, still get a list to filter. But the code doesnt work.. Is there a way to fix this?
(the code does work if I just type in the partner, but I it has to refer to the main sheet, because if a partner changes, I wanted it to automatically change in all the sheets.)
An option would be to use the Worksheet_Calculate event, although the overhead is much larger.
See the attached version.
- Thanks a lot for the help!
It sadly didn't work to refer te cell to the mainsheet.