Copying certain columns from one sheet to another based on the value on one column

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

Originally Posted by Richard Buttrey

Hi,

Have you tried Advanced Data Filter?

Thanks for your reply.

It needs to happen dynamically, so it shouldn't have to be intervened at all.

I suppose this does need Macro to work.

Can someone please have a look and pitch in?

Many thanks,
TR

Originally Posted by Richard Buttrey

Hi,

You'll need to upload the workbook. Manually add the results you expect to see and explain how you produced them, e.g. what rules you've applied. No doubt we can then work something out.

Hi,

Please find the attached Excel file. Hope this explains what I want it to do, please let me know if you have any questions.

Thanks.

Attachment: sample.xls