ammad134's blog
How to filter multi column data and then appear filter data in seperate sheet
Submitted by ammad134 on 6 April, 2015 - 07:35I have excel sheet that have more than 100 column. I want to make easy interface for user, my requirement is below.
detail of sheet are like
1- Column A to H are fixed and I want to filter the remaining column like I to Z.
2- When I filter the column I want the result that it will show only column that I filter and starting column A to H.
3- user interface is like drop down search of column I to Z.
»
- 4 comments
- 12192 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago