Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to move certain data to different sheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move a row of data from one work sheet to another using a formula | Excel Worksheet Functions | |||
How do I move daily data from one sheet to a 'yearly sheet' | Excel Worksheet Functions | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
formula to add certain data and then move to another sheet | Excel Worksheet Functions |