Hi all,

This is a bit tricky to explain so I will do my best - please let me know if you need further clarifications.

I have a master data sheet with the structure as below:
exc2.png

I need a few of the columns (i.e. not all) to be copied to another (filter) sheet (starts from Row 20 say). The "notes" column should be fed back to the master list. If the condition changes in the master list, the entire row (including the data entered in notes) should be removed on the filter sheet.

The filter sheet structure is as below:
exc1.png

I initially used Index, Small, Countif to pull data to the filter sheet but could not "input" into the cells as they all held formulas in order to copy to the new sheet.

Please let me know if you have any questions.

Many thanks for your help,
TR