Hi All -

So, I'm familiar with sharing data between two sheets using a format like:
=sheet1!A1

However, what I'd like to be able to do is have two cells with the same data so that if I change either one, the other updates also. The value OR the formatting (say I change font color to red. etc.).

An example would be along the lines of a "master list" of customers on sheet1, with columns: Name, Product, Date, Paid (y/n)

On sheet2, I'd like to display a subset of this list, say only the customers with Name=Smith.

But, say on sheet2 I have Bob Smith who is not paid and I want to mark his record to update Paid to "y"... Is there a simple way to do this on sheet2 and have the data on sheet1 be updated? In this case, the data on sheet2 is being "pulled" from sheet1, but is there a way to "push" changes back to the sheet1 data?

I of course also want to be able to make changes to data on sheet1 and have it update on sheet2.

Also, I'd like to be able to apply bold or whatever while working in the subset on sheet2 and have that apply back to the "source" record in sheet1. And vice versa.

Any advice?

Thanks!