Need help in copy and pasting multiple lines based on a criteria

[xlbaby]

Hi all,


I need an urgent help on a macro. I have very minimal experience with Macro and is struggling to get this done.

I have a spreadsheet that has close 22K rows with a lot of data. The data is spread across various columns. The cell A1 is the unique id which repeats in various rows.

Criteria Tab: The criteria using which the output needs to be generated. Unique ID (with duplicates removed)
Data tab: The tab where the data is available. The columns where the data is available is on the top row
Output tab: How I want the output to be.

What I need is an output where all the same unique id details are copied and pasted in an order sorted A-Z based on the unique id. The unique id (after removing duplicates) will be in a separate tab within the sheet.

I will have multiple tabs with the data I need to copy. The spreadsheet that I have attached has all the details.

I hope I have explained it properly. If not, I am ready to give additional details.

Thank you so much for your help.

Help Needed.xlsx
	A	B	C
1	EEID
2	AAB11
3	ABB12
4	ABA11
5	ABB13
6
7
8
9
10
11
12
13
14
15
16
17
Criteria

Help Needed.xlsx
	A	B	C	D	E
1	Cell A1	Cell V1	Cell X1	Cell AA1	Cell AC1
2	EE ID	Date Purchased	Date Sold	Units sold	Price
3	AAB11	12/14/2012	6/2/2020	977	53
4	AAB11	3/21/2012	5/12/2020	890	99
5	AAB11	7/11/2009	5/6/2018	979	98
6	AAB11	11/19/2014	11/2/2019	819	78
7	ABA11	4/27/2013	5/2/2018	399	72
8	ABA11	3/30/2012	4/29/2018	657	81
9	ABA11	5/30/2010	9/9/2018	214	57
10	ABA11	9/18/2012	5/29/2020	361	90
11	ABB12	3/30/2013	12/5/2017	904	69
12	ABB12	4/12/2010	10/1/2018	688	96
13	ABB12	8/23/2010	10/8/2018	167	85
14	ABB12	8/20/2013	2/29/2020	619	63
15	ABB13	10/12/2012	4/1/2019	763	100
16	ABB13	10/3/2011	10/28/2018	764	64
17	ABB13	4/25/2012	12/22/2019	812	80
18	ABB13	8/20/2010	5/30/2018	345	82
Data

Help Needed.xlsx
	A	B	C	D	E
1	EE ID	Date Purchased	Date Sold	Units sold	Price
2	AAB11	12/14/2012	6/2/2020	977	53
3	AAB11	3/21/2012	5/12/2020	890	99
4	AAB11	7/11/2009	5/6/2018	979	98
5	AAB11	11/19/2014	11/2/2019	819	78
6	ABA11	4/27/2013	5/2/2018	399	72
7	ABA11	3/30/2012	4/29/2018	657	81
8	ABA11	5/30/2010	9/9/2018	214	57
9	ABA11	9/18/2012	5/29/2020	361	90
10	ABB12	3/30/2013	12/5/2017	904	69
11	ABB12	4/12/2010	10/1/2018	688	96
12	ABB12	8/23/2010	10/8/2018	167	85
13	ABB12	8/20/2013	2/29/2020	619	63
14	ABB13	10/12/2012	4/1/2019	763	100
15	ABB13	10/3/2011	10/28/2018	764	64
16	ABB13	4/25/2012	12/22/2019	812	80
17	ABB13	8/20/2010	5/30/2018	345	82
Output