Hi,
I have a planning dashboard which will provide the various aspects regarding the employee.
There are 3 sheets
Decision support tool
9-Box distribution
Emp Database
In Emp Database WS is where all the Employee Database is stored. B35 to AB35. The same range for Decision support tool WS and 9-Box distribution WS.
In Decision support tool WS I have created buttons for various Groups (Group2, Group3, Group4...)
My Requirement is,
Requirement 1
In Decision support tool WS, when I select the Tower from the drop down F23 and its related Group in F24 and click on Run (button), I want to display the content in Columns B to O for the select tower and its related group. (The data should be picked from the table in Emp Database WS).
In Decision support tool, For that selected Tower and for selected Group, when I click on the Buttons (Group2, Group3, Group4, Group5, Group6) based on the employee group the content should be displayed.
For Example I have selected Tower1 in F23 and Tower_1_Team_2 in F24 and when I click on the any of the button (Group2, Group3, Group4, Group5, Group6), I want to display the content for that particular group which I have clicked.
Is this possible?
Requirement 2
In Decision support tool, Columns Q to V and X to AB are updated manually by the managers.
When they update the information in those columns and click on Update Data Button, I want the data for the selected Tower and selected Group employees data to be updated in the Emp Database Worksheet for those employees listed in the Decision support tool and for which the data is entered manually.
Please help me out in this.
Your Help in highly appreciated.
Thanks in Advance.
Sample attached.