Auto Add Row From Main Tab To Other Tabs Based On Cell Value

[zunebuggy65]

I have a large spreadsheet with a large amount of data in Sheet1 named (for example) Main.
In column B of Main I have text that can either be A, B, C, D or E
I want to have Sheet2 named A, Sheet3 named B, Sheet 4 named C, etc. and when I add data in Main, it will auto add that same data to the other tabs based on what column B is. For example, I add a line where column B = "C", I would like the "C" tab to add that same line of data as well.

So basically I enter the data once into Main, but using a conditional "If" type logic based on contents of column B, it will also add it to only the corresponding other tab and not the other tabs.

I hope I explained it well.

Thank you

[dosydos]

well since your using excel 365
i would suggest using FILTER function
In tab "A"

=FILTER(Main!$A:$C,Main!B:B="A")

repeat for tab B and C etc etc

[zunebuggy65]

Thank you! That worked perfectly!

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.