Help with formula: Seperate Items into new tabs.

[Surreyview]

Hello,

I don't know whether what I am trying to do is possible?

I have a summary tab in my spreadsheet that has a number of New and Existing Accounts.

I need to have two further separate tabs: one that displays only the new accounts and relevant data associated to that account, and the same for only the existing accounts.

How do I get my two new tabs to look for the data and populate it?
Thank you

 

[AlanY]

on the summary tab, how do you know which account is new or existing?

 

[Surreyview]

Thank you for replying.
I have a column that states which account is a 'New Account' and which is a 'Existing Account.

 

[Joe4]

How about just using Filters or Advanced Filters?

 

[Surreyview]

Yes, I was hoping to do something a bit more sophisticated, but actually I might propose we do that initially and see how we get on.
Do you think what It is not possible to do it any other way?

 

[AlanY]

like this?

Book1
	A	B
1	Account1	New
2	Account2	New
3	Account3	New
4	Account4	Existing
5	Account5	New
6	Account6	New
7	Account7	New
8	Account8	Existing
9	Account9	New
10	Account10	New
Summary

Book1
	A
1	New
2	Account1
3	Account2
4	Account3
5	Account5
6	Account6
7	Account7
8	Account9
9	Account10
New

Cell Formulas
Range	Formula
A2	{=IFERROR(INDEX(Summary!$A:$A,SMALL(IF((Summary!$B$1:$B$1000=A$1),ROW(Summary!$B$1:$B$1000)),ROW($A1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Book1
	A
1	Existing
2	Account4
3	Account8
4
5
6
7
8
9
Existing

Cell Formulas
Range	Formula
A2	{=IFERROR(INDEX(Summary!$A:$A,SMALL(IF((Summary!$B$1:$B$1000=A$1),ROW(Summary!$B$1:$B$1000)),ROW(New!$A1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Surreyview]

Thank you everyone. this is so helpful.