Hi all,

I have been researching for days but I can not find a solution for my problem. I do not have any experience with programming in Excel.

I have a "Main sheet" with lists of contacts, fields are; name, number, e-mail, notes, and importance.

What I want to achieve is rows that are marked with importance "1" is mirrored to another sheet named "Important". This could be achieved with macro and copy everything based on a criterion,
but I want to be able to change the notes in the "Important sheet" and the changes will also happen in the main sheet. Also if I wanted to change the name, number or other fields.

So what I basically want is to two-way mirror the whole main sheet to another sheet and filter it by a criterion.

Hope someone could help me with this.

Thanks!