Macro to activate a filter on another sheet

[The_jackal]

Hi everybody,

I would like to know if is it possible create a macro activated by a certain array...

For example: when i put in a certain coloumn a certain array (for example "apple") the macro should start and activate a filter in another spreadsheet...

I don`t know what i`ve to put before

Please Login or Register  to view this content.

Thanks for help

[VBA Noob]

The_jackal,

Thread moved to programming and code wrapped for you this time.

Please read the forum rules below and confirm yo understand them

This can be done. Can you provide a sample workbook

VBA Noob

[The_jackal]

I attached the samples...i nd that when i write "orange" in spreadsheet2 the filter in sheet1 update itself in the way to have always updated data
Thank you

[VBA Noob]

Right click sheet 2 > select view code > paste in the below

Please Login or Register  to view this content.

HTH

VBA Noob

[The_jackal]

The macro works very good, but I would like to activate the filter only with the word "orange"...
I tried to change the criteria but i didn`t succeed in...

[VBA Noob]

Maybe

Remove the ' if you need the message

Please Login or Register  to view this content.

VBA Noob

[The_jackal]

Now the macro works in the way that i like....but if I try to apply it in the real document it doesn`t work..I`ve changed the values and this is the resulting

Please Login or Register  to view this content.

I attached a sample of the document with the real spread sheet name and the right coloumns and formulas...where is the mistake?

Thanks for your help

[VBA Noob]

Try

Please Login or Register  to view this content.

[The_jackal]

Now works properly, the only thing I had to change was the field (from 1 to 4) otherwise the "Re-weighting" activated the coloumn A filter...
Thank you a lot

Please Login or Register  to view this content.