• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA coding for Filters

M

msharma864512

Member
Hi,

I am looking to provide three drop downs, which will apply filters on certain column and reflect the whole data on the basis of applied filters, however all the dropdown should be linked.
For e.g if we click on commodity chemicals, it will apply filters on column J and will only reflect data for commodity chemicals, and after that if we apply filter on region and select Americas, then it should reflect data for commodity chemicals of americas region.

All the filters should work in similar way.

Please help me with the same.

Regards,
Manish Sharma
 

Attachments

  • MAcro for Filter.xlsx
    186.5 KB · Views: 3
Here is how this template has been designed..
I have created drop down lists on Companies list worksheet (I have highlighted these in yellow color) using dynamic named ranges created in Lookup worksheet

One you select the sector, the corresponding Region names populated, Once the region is selected the company size drop down gets populated..

Once the Company size is selected the data in worksheet gets filtered...

Not sure, whether I have shared the correct file in my last update..please consider this..
 

Attachments

  • MAcro for Filter.xlsm
    200.5 KB · Views: 3
Ramesh said:
Here is how this template has been designed..
I have created drop down lists on Companies list worksheet (I have highlighted these in yellow color) using dynamic named ranges created in Lookup worksheet

One you select the sector, the corresponding Region names populated, Once the region is selected the company size drop down gets populated..

Once the Company size is selected the data in worksheet gets filtered...

Not sure, whether I have shared the correct file in my last update..please consider this..
Click to expand...
Hi Ramesh,

Thank you for all your help, however it is still not working the way I am looking for.

Actually whenever I apply any filter whether its sector, region or company size, it should reflect the data accordingly.

For e.g, if I apply filter on sector and choose specialty, then the data will show only for specialty. Now, if I further want to apply to filter on any region or company size, it should reflect the data accordingly.

And its not necessary, that sector should be the first filter, even if I want to apply filter only on company size, it should reflect the data accordingly.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
​
 
You must log in or register to reply here.
Back
Top