I need a dynamic sheet containing a subset of the data based on criteria from one column of my main spreadsheet, without having to go through the filtering process each time I need it.
I have a list of projects on an ALL PROJECTS spreadsheet, containing details such as Project Name, Status, Manager, Budget, and other details specific to the project.
Some of the projects are in process, some are in planning, some are awaiting approval, etc.
What I need:
- separate sheets for each status: Planning, Awaiting Approval, In Process
- the separate sheets need to contain all of the details of each project
- the sheet should automatically update when information on the project is changed on the ALL PROJECTS spreadsheet
- I need to be able to flip quickly between the various sheets
- I need to be able to print the sheets with no filter or pivot table displays
I’m new to Libre Office, and I would appreciate any help.