S
Shu of AZ
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
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