Forum Discussion
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 they recieve points per task. But, they don't need to see the other partners. They now see a complete overview, I want to minimaze that.
So, I want an option to filter partners, and the result has to be that they only see their party and their responsibility. In the filter option, I also want the "All" function, so that they still can see a overall overview ( situation atm).
To show what I want, I've added the table that I use ( but blank), and the result I want.
Who can help me?
Thanks!
Result has to be:
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.
10 Replies
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, this was what I needed. But, how can I add this in my project? I've never used it.
You can copy the code from the worksheet module in the demo workbook to the worksheet module in your own workbook.
You'll then have to modify it because your worksheet probably uses different columns for the partners.
You'll have to save it as a macro-enabled workbook (.xlsm).
If you wish, you can attach a copy of your workbook without sensitive data, or make it available through OneDrive, Google Drive, Dropbox or similar.
