Hi, I need a help to create a vba code for following task.
I have 2 pivot tables. pivot table 1 showing the parent unit and component list.
Second Pivot table showing the details of revenue, production information for the component list.
what i need is when the user to key in the parent unit desired,
a. pivot table 1 will show the parent unit desired and its component list
b. pivot table 2 will show the details base on component list from pivot table 1.
I create a simple excel, can anyone help ? i'm a bit stuck. the actual report that i need contain a thousands of line item, and one parent unit can have as much as 50 component, so to do it manually is not preferable.