Two way mirror sheet by criterion

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!

Hi,

Thanks for the reply. I have attached the file.

Thanks! I have been struggling with this for so long.

I had to assign the "Refresh" macro to the button, but everything else worked like a charm! How hard is it for me to add more Status (3,4) and more Sheets with same functionality? Can I reuse your code easily?

Again, thanks!

Hi, I got it to work :-)

One thing I notice is that if a field (for example telefon) is blank when added to status 1, it is not possible to add info to that cell when you are in Status sheet 1.

There has to be something in that cell for it to mirror both ways.

Is this something that can be fixed?

Everything else works fine, I really appreciate the help.