Hi,
I have a two following sheets that I'd like to use dynamically when changing the product filter on pivot table.
My first table 1 has the following info. Date and ACTM3 are from pivot table, outbound qty a manual addition next to pivot:
Second sheet having the following table 2:
Then by changing the Product code filter to some other product, I'd be looking to find the right figure from table 2 to table 1. Tried Index match functions but somehow didn't work.
Anyone could help with this? Much appreciated.
I have a two following sheets that I'd like to use dynamically when changing the product filter on pivot table.
My first table 1 has the following info. Date and ACTM3 are from pivot table, outbound qty a manual addition next to pivot:
Second sheet having the following table 2:
Then by changing the Product code filter to some other product, I'd be looking to find the right figure from table 2 to table 1. Tried Index match functions but somehow didn't work.
Anyone could help with this? Much appreciated.
