Populate multiple tabs based on input in Master tab?

[MjRmatt]

Hi,

I'm not sure what to use to populate multiple tabs based on information inputted into one tab. I think possibly an array?

On the attached example I need all data for each Company to be pulled from the Master and populated in the appropriate tab. Essentially the end result is the master is populated and the other tabs automatically populate themselves.

Is it possible?

[Debraj Roy]

HI, Try this Array Formula in both sheet..

Please Login or Register  to view this content.

Attachment 251100

[MjRmatt]

Thank you, I was unsure which section to post this in so apologies for the duplicate post.