Lookup data and paste on new sheet

Closed
tone - Jul 26, 2010 at 07:37 PM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 30, 2010 at 09:40 AM
1