The data table contains information for Co # 130 Co #140 Co #180 ,etc Col 1 has Co Nbr, Col 2 Div Col 3 Location Col4 Year Col 5 Type (Actual or Plan) Col 6 - 17 has monthly totals
Created three pivot tables [one for current year actual, another for plan, and another for prior year data] on one worksheet. I need to update them based on selecting the Co number from a drop down list on another worksheet. Further selection by division and location #'s is also desired.
Created three pivot tables [one for current year actual, another for plan, and another for prior year data] on one worksheet. I need to update them based on selecting the Co number from a drop down list on another worksheet. Further selection by division and location #'s is also desired.