Formula to move certain data to different sheet
 

The cell values below are on one sheet and is much more than the example. I
need to pull only the data that has the number 1 in the first column to
another sheet (SheetData). I will then have to pull the '2's' from the
original sheet to SheetData but in a different area of the sheet and so on.
Is there a way to look at the entire table of data and be able to copy and
paste only the data based on the numeric value in the first cell. Thanks in
advance.

1 Thelifeoftheparty 1 1-May
1 Buck's Bounty 2 1-Dec
1 Jenny's First Gear 3 1-Oct
1 Shesourkindagal 4 1-Feb
1 Winningdancer 5 1-Mar
1 Beautiful Jen 6 1-Jun
1 Apache Annie 7 1-Apr
2 Smarty Matt 1 1-May
2 Holloman 2 1-Feb
2 Dane's Klinsman 3 15-1
2 Justa Groovin 4 15-1
2 Pendleton 5 1-Mar
2 Benton Paige 6 1-Jun
2 Pittsburgh 7 1-Jun
2 Clints Well 8 15-1
3 Mello Nello 1 2-Jul
3 Angular Momentum 1A 2-Jul
3 One Last Crime 2 1-Mar
3 Rasin a Delight 2B 1-Mar

Formula to move certain data to different sheet
 

See ans in your other post.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shu of AZ" wrote in message
...
The cell values below are on one sheet and is much more than the example.
I
need to pull only the data that has the number 1 in the first column to
another sheet (SheetData). I will then have to pull the '2's' from the
original sheet to SheetData but in a different area of the sheet and so
on.
Is there a way to look at the entire table of data and be able to copy and
paste only the data based on the numeric value in the first cell. Thanks
in
advance.

1 Thelifeoftheparty 1 1-May
1 Buck's Bounty 2 1-Dec
1 Jenny's First Gear 3 1-Oct
1 Shesourkindagal 4 1-Feb
1 Winningdancer 5 1-Mar
1 Beautiful Jen 6 1-Jun
1 Apache Annie 7 1-Apr
2 Smarty Matt 1 1-May
2 Holloman 2 1-Feb
2 Dane's Klinsman 3 15-1
2 Justa Groovin 4 15-1
2 Pendleton 5 1-Mar
2 Benton Paige 6 1-Jun
2 Pittsburgh 7 1-Jun
2 Clints Well 8 15-1
3 Mello Nello 1 2-Jul
3 Angular Momentum 1A 2-Jul
3 One Last Crime 2 1-Mar
3 Rasin a Delight 2B 1-Mar