Macro to paste data to new tab based on changes in ID

[SereneMal]

Hello all, hoping someone can help me out. I have a report that I download with client account numbers as an identifier and several fields that are associated with that ID. I would like to build a macro that will cut/copy and paste all the rows that have the same account number into a new tab.
Columns: fixed number of columns, with consistent header
Rows: the number of rows associated with each unique account #/ID constantly changes.
Unique IDs: variable or fixed @ 10 if needed*
*The tabs can be pre-created blank or with the header and named e.g. Acct 1, Acct 2... Acct 10.
Let me know if any more specifics would be of assistances.
Thanks for looking!

Sample Output.xlsm
	A	B	C
1	Account Number	Product	Quantity
2	Acct #1	Oranges	2
3	Acct #1	Cherries	5
4	Acct #1	Limes	4
5	Acct #2	Cherries	12
6	Acct #2	Broccoli	1.50%
7	Acct #3	Salad	1000
8	Acct #3	Cherries	50
9	Acct #3	Oranges	25
10	Acct #3	Melons	66
11	Acct #3	Figs	7
12	Acct #4	Limes	-2
13	Acct #4	Salad	5.50%
Sample Output

Sample Output.xlsm
	A	B	C
1	Account Number	Product	Quantity
2	Acct #1	Oranges	2
3	Acct #1	Cherries	5
4	Acct #1	Limes	4
5
6
Acct 1

Sample Output.xlsm
	A	B	C
1	Account Number	Product	Quantity
2	Acct #2	Cherries	12
3	Acct #2	Broccoli	1.50%
4
5
Acct 2

 

[Joe4]

Welcome to the Board!

Since you have the newest version of Excel (365), the easiest way would probably be just to have the one sheet with ALL the data (like you show), and then just use the new FILTER function on each of the individual pages that follow. That will dynamically pull all the matching data from your front sheet. And the best news is that you may be able to do all of this without any VBA, if you know how many different accounts you are dealing with (so you can set up a tab for each).

See: FILTER Function

 

[SereneMal]

That is awesome, thanks!
Had to create a slight work around since the identifiers ("include" argument in FILTER) is constantly changing. Essentially, I added a new "Identifier" tab and use UNIQUE to create the list of identifiers. Then I set "include" = those identifiers, #1-10.... so 10 tabs.
Happy times!

 

[Joe4]

You are welcome. Glad I was able to help.

Yeah, that new function is really cool! I really like how it dynamically adds the right number of rows and columns, depending on your data.