Lookup data and paste on new sheet

Closed
tone - 26 Jul 2010 à 19:37
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 Jul 2010 à 09:40
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 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
30 Jul 2010 à 09:40