Pivot Key ..Help

[mart1nss]

Dear Excell Master

Kindly your help that i have two sheet in excell. As per attach file sheet Total contains data total stock and second sheet contains detail stock per sales office
I want filter in total sheet per material (one material) and become auto filter in branch sheet that refer material in total sheet. so i don't filter twice in every sheet.

Kindly your help. Thank you in advance

 

[vletm]

mart1nss
There were four sheets...
'TOTAL'-sheet has 'STOK TOTAL's ... but from where?
I did Pivot-table to TOTAL.
It looks someway like Your.
... Pivot-table has to refresh after modify BRANCH-sheets data.

 

[mart1nss]

kindly forget the number

that i mean is if we choose one material in total sheet, so branch sheet auto display for one material that we choose in total sheet , the 2 sheet connect

thanks you

 

[vletm]

mart1nss
I figure the 1st and last lines.
Between those
... nothing auto this-or-that way or whatever image would You have.