How to write a variable in autofilter for dynamic selection

[brijendraydv]

Hi Experts,


I am attaching my file in this link: http://speedy.sh/XpcGs/Anlage-1-WKZ-Formenbau-Fischer-2.xls


what all i want is that if i go to tablelle2 sheet and there in combobox i need to link all vendor names where i need to select any vendor name value which is present in Tabelle1 sheet in column E then the corresponding filter result for that vendor name should come in tabelle1 sheet.


Regards,

 

[brijendraydv]

pls reply on this.


Thanks,

 

[smanjunath]

why don't you simply use pivot table?


If u need help in Pivot table creation, pl let us know.