sheet export based on selected data

Hey,

I need some help.

I have a large dataset with the following columns (system/subsystem/hazard identification/risk estimation/safety measures). The image below is not in English, but hopefully it will help to understand.

The result should be a separate sheet of the dataset with the same columns (system / subsystem / hazard identification / risk estimation / safety measures). Based on the selection and labelling of the SYSTEM/SUBSYSTEM columns.

The actual selection of data based on the SYSTEM/SUBSYSTEM identification should be in a similar format to the drop-down library shown in the figure.

Thanks for help.

MacBook Air 13″, macOS 13.0

Posted on Nov 25, 2022 7:18 AM

Similar questions

Dynamic table of workbook sheets/cell values As part of our internal Scrum "process" I need to produce documentation for some ISO certification stuff. So, every sprint start I need to produce a Sprint Planning Document and at the end of the Sprint, a Sprint Report. He have template for this that were initially produced in Excel, but we've moved them to Numbers, since everyones on Mac now. I change the file in order to have more info and extract some insight. I've originally made it on Google Sheets, and using javascript scripts I was able to automate everything I needed and produce dynamic graphics and tables. However, due to security policies, I had to remove everything from Google and use only local files, on Numbers and I'm not being able to produce this reports automatically. My current file in numbers have, for each Sprint, three tables: One for Sprint Planing (left) One for Sprint Report (right) One for Summary (bottom) This Sheets have other tables with all the items from were I'm getting some other data/values. For each Work Sprint I create a new sheet named "Sprint + (number of sprint)" by duplicating a template sheet that I also have on the same Numbers document. I start by Filling in the green cells on the Summary table that auto-fill the required fields on both reports with similar values. What I need and I'm not being able to do is to have a "Totals" Sheet with dynamic table that automatically fills in the values for : Commited Scope Delivered Scope Missed Scope etc... every time I create a new "Sprint" Sheet. Since there's some limitations in Numbers compared to Google Sheets, I'm considering create a new line on this table manually for every sprint, entering only the sprint number on some column and then Numbers would go to the appropriate Sheet to pick up the values. I've tried Apple Script using Javascript but the documentation is so poor that I couldn't achieve anything... Is it possible to achieve this? Any direction would be appreciated.
903 7

3 replies

SGIII

Level 8

37,550 points

Nov 25, 2022 7:31 AM in response to TheKlobb

Could you give an example of how you want the exported data to look in the destination table?

TheKlobb Author

Level 1

8 points

Nov 25, 2022 8:32 AM in response to SGIII

TheKlobb Author

Level 1

8 points

Nov 25, 2022 9:09 AM in response to TheKlobb

ok I can do it with just a quick filter, but it's user unfriendly

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

sheet export based on selected data

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up