Forum Discussion
Excel filter and hide other columns
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.
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.
Still doesn't work.. I've copied the VBA and modified it, but it still didn't work.
Below my workbook without data. Ive 5 sheets in one workbook, so I've made a new workbook with only 1 sheet.
