Lookup data and paste on new sheet

Closed
tone - Jul 26, 2010 at 07:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 09:40 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 30, 2010 at 09:40 AM
1