Hi All,

I have a main list I maintain on spreadsheet. However, I want to create a new list (which is only partial of the main list) that automatically updates itself dependant upon a criteria.

For instance, if the third column ( A yes or no column in the main list) is a yes, then it adds the entire row from the main spreadsheet into the new list. (I know I could alternatively filter the third column in the main sheet and then manually copy and paste this into the secondary list, but I'd prefer if this was done automatically).

The end goal: fill out the main sheet manually, but if there is a 'Yes' in the third column, then it also adds this row into my secondary list.

The reason I need a solution to this is that there is actually multiple main lists, and only one secondary list.
Thanks for any help in advance!