Attached is an example of solution I described in my previous post.
In Table on sheet Data are 11 rows of data with different ID values.
In Table on sheet IdList are entered ID's you want to follow.
For Table on sheet Data is set a filter for column InList = TRUE, so only rows you want to follow are displayed.
In case you add new records to filtered Table on sheet Data, you have to refresh the filer to get the table filtered properly (obviously new ID's are missing from IdList Table, so you must get those entries to be hidden - or add them to IdList Table too).
With Table I mean Defined Table.
|