Hi all
I would like to know is it possible to extract the data to a new spreadsheet from a table based on click on a specific item.
I have production employees who are all assigned to a several unique production items.
To keep track on a production a have created a table (countifs) for each production stage to know how much time is each item (each item has unique ID) in one particular production process.
For example; employee 1 has:
- 7 items are in the first production stage between 7 and 14 days
- 3 items are in the first production stage between 14 and 21 days
What I would like to achieve is that by clicking the employee name i get listed out all items ID and how long they are in that particular production stage.
Example:
Capture.PNG
Bookmarks