Challenge :-)

[Nabil Syed]

Please give me a solution for the below....
I have a huge data from A1: P830 in sheet 2,
REGION Broker TYPE CODE Co NAME CITY CLASS Service for Class C Expiry Date PHONE FAX

In sheet 1 have some condition as CODE, CLASS & REGION and one button with hyperlink as GO
Question: what is needed is that if i select the above condition in sheet1 (entered as data validation) and press GO then the data of sheet 2 must be filtered as per the conditions/criteria selected in sheet1

i hope that the above is well explained.

waiting for the solution

thanks in advance.

 

[Hui]

Nabil

Have a read of posts on Advanced Filters

 

[Nabil Syed]

Mr. Hui,
i read the post of Advance filters but the problem for me is when im changing the condition the data is not updating auto.. each time i have to do advancefilter which is driving me crazy...
hence i want to update the data based on the condition numerous times

 

[json]

I've done something (kinda) similar but my criteria doesnt really change.... anyway, i created a quick macro; recorded myself setting up the advanced filter. That way, instead of haveing to tun the filter off and then back on, i just hit the button... something like this may work for you.

but, seriously.... could you give more information or upload a sample? The game that you implied is not a fun one

 

[Hui]

You could add a small macro and a button to execute it automatically for you
Posting a sample file would help us help you

 

[kchiba]

Hi Nabil,

Look at this post it has a file with a Macro to do the Advanced Filter

http://chandoo.org/forum/threads/generic-advance-filter.13613/

cheers

kanti

 

[Nabil Syed]

Hello Kanti,

Many thanks for your reply.... it really helped me a lot... and i must say that ur too good in understanding the queries....
you are too awesome.... cheers!!!!!!!