Home » Blogs » 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:35

I 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.

AttachmentSize
New Microsoft Excel Worksheet (3).xlsx15.23 KB
»

How to filter multi column data and then appear filter data in s

Submitted by ammad134 on 22 April, 2015 - 06:32.

dear Amron, please email the solution on my email address
ammad134@yahoo.com.

I will be very thankful to provide the solution.

Regards

»

i hope amrom will gonna

Submitted by jamesseals on 22 April, 2015 - 04:58.

i hope amrom will gonna provide you the exact solution. if not, the online world is of great help to you. all the very best.

»

Hello, If I understood

Submitted by amrom on 12 April, 2015 - 14:48.

Hello,

If I understood correctly what you need , then I have what you need , let me know where can I send you the file. I see no option to attach files here.

Regards,

»

How to filter multi column data and then appear filter data in s

Submitted by ammad134 on 22 April, 2015 - 06:34.

please provide the solution on my email address.

ammad134@yahoo.com

I will be very thankful to you.

Regards

»