Lookup data and paste on new sheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
my data is set up as below
A 1234
B 2345
C 78
A 553
C 345
A 247

I want to select all A's in column 1 and paste rows on new sheet, B's on new sheet..ect

Any help would be great

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month