Variable Filter

Hi

I am setting up a dashboard and have two variables, min sales and % growth which the user can change

I have sales data in sheet sales data and want to run a filter on the sales data in that sheet using the variable data

so filter on min sales (>=min sales) and (>= min % growth)

Thanks a million

Hi

You can use the filter (on the data menu) and select custom filters and then you are able to set two custom ranges and select the filter you want i.e. greater than x, equal to y, less than z etc.

Hope this helps

There is no direct way... to add a cell reference in the conditions...
I think you should try your luck in the vba section..



Say thanks, click *

Ok
one second ...
I got an idea with the vba..
wait a minute I will be there with solution...

Mission Accomplished bro..
I did it..
check the attachment....
I have use a macro in sheet1
you can always change it to your requirement..
otherwise give me a private message..

while changing the conditions .. do use a suffix like = or > or < don't miss it..


say thanks, click *