Array formula? Populate tabs based on 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?

[NeedForExcel]

Will VBA be ok with you?

[MjRmatt]

If that's the only way to do it?

[NeedForExcel]

Nope.. can be done with an array formula too.. But then your sheet will always be flooded with formulas, but at the same time it will be real time.

[Fotis1991]

Hi

Try this in B8 of Company A sheet, this ARRAY formula. Copy down and across.

=IFERROR(INDEX(Master!B$5:B$1000,SMALL(IF(Master!$E$5:$E$1000=$B$5,ROW(Master!B$5:B$1000)-4),ROW(Master!B1))),"")


-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

[Debraj Roy]

http://www.excelforum.com/excel-gene...aster-tab.html

Duplicate Post

[NeedForExcel]

Here!

Commit by using Ctrl+Shift+Enter

Please Login or Register  to view this content.

[MjRmatt]

All solutions are great. One more possible addition; Is their a way for the multiple tabs to update whilst clearing and repopulating the Master tab? i.e. starting the Master from fresh each time whilst storing the previously inputted data on the other tabs?

[Fotis1991]

As my English are not so good not sure that i understand your question. Do you mean if you clear all the data from Master sheet and put new data there if the other tabs will get the new data?

[MjRmatt]

Yes, but also retain the old data.

[Fotis1991]

Answer is no. If you delete the old data then you have no old data!!