Auto Populating Report or Sheet with New Rows from Master Sheet
I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet.
For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project has a set of tasks that must be completed. For various reasons, I cannot include these tasks on the main project sheet as columns.
What I would like to do is have a separate sheet or report (I don't care which), that will display all projects from the first sheet, then have subsequent columns like Task 1, Task 2, Task 3, that can be checked off when each is completed for a project. This sheet / report must have the ability to pull in any new projects that get added to the master project list.
I've tried to do this with cell linking, but I cannot get new projects that are added to the master sheet to appear in the secondary sheet without setting up new links.
I've also tried to do this with reporting by setting up a sheet that has each task listed as a separate column (Task 1, Task 2, etc.) and creating a report that combines my master project sheet with the task sheet. I can get the task columns to appear in the report, but cannot edit them since these columns do not appear in the master project sheet.
I figure there has to be a way to do what I'm trying to do, but cannot figure out.
Thanks in advance for any help you can provide!