SOLVED

macro to filter all tables in workbook based on the given figure

Contributor

I need to create a macro to filter all tables' different worksheets (Last year Sales ,  Open customer orders , Open orders to vendors ) in the attached workbook based on the given value in attached workbook. or I need to filter all tables in different worksheets (Last year Sales ,  Open customer orders , Open orders to vendors ) when double click on the item code cells in the "data" worksheet. can anyone help me to do this in this worksheet itself

2 Replies
best response confirmed by Ravindu94 (Contributor)
Solution

@Ravindu94 

See the attached version.

Hi @Hans Vogelaar

this is really helpful.

thank you