Help: I have a master tab and want other tabs to automatically update

Hello,

I have a workbook that has a master tab with all of our clients as well as certain details. For example, one of the columns is "Partner", i.e. which partner is over the client. So when we add a new client to the master tab, I enter the company name and which partner is over the client. I have separate tabs for each partner, and so I have to manually copy and paste the row of data to the corresponding tab.

I am wondering if there is a way to have the corresponding tab automatically update with that row of data. So lets say I have a new client called Company X and Peter is over Company X. When I enter Company X's information onto the master tab, I would like Peter's tab to automatically update with Company X's information as well.

Is that something that can be done in Excel?

Hi JBeaucaire,

Thanks for your response. I should have been more clear. On each tab, I have a formula in a separate cell that calculates a score. So on the master tab, that score is calculated based on the values for all of the clients. If I just sort so I can only see Peter's clients, the formula doesn't change and it still has all of the other values included in its calculation.

That's why I have them on separate tabs. I have a cell with the score on Peter's tab and so on and so forth. But as you said, I may be working too hard. Maybe there's a way that the formula can reflect the values that show when a filter is applied? That would be much easier.

Here is the formula I have to calculate the score: =ROUNDUP((100*((COUNTIF(A:A,">8")-COUNTIF(A:A,"<7"))/COUNT(A:A))),0)

Thanks again for responding. Okay, I've attached a spreadsheet with some obviously fake data (we don't actually count Warren Buffett or LeBron James as clients). The purpose of this spreadsheet is to calculate the Net Promoter Score, and I have a formula in cell I2 that calculates that based on the numbers that are entered into column A.

It would be ideal if there was any way I could filter the partner column so it just showed Brooke's clients, for example, and the NPS formula in I2 updated to reflect only the data that was visible.