| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I have a large sheet (200X200 approx) of individuals that has name, team and a number of Stats. I need some way of moving details of an entire team (10 rows) data to a different location/sheet. I want to be able to put the team code into a cell and all of the data for that team appears underneath for whichever column required (sales etc) Can this be done and where to start? Tom  -- tom300181 ------------------------------------------------------------------------ tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580 View this thread: http://www.excelforum.com/showthread...hreadid=392165 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Why not...
Data>Filter>Autofilter ? HTH, -- Gary Brown gary_brown@ge_NOSPAM.com If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "tom300181" wrote: > > I have a large sheet (200X200 approx) of individuals that has name, team > and a number of Stats. > > I need some way of moving details of an entire team (10 rows) data to a > different location/sheet. I want to be able to put the team code into a > cell and all of the data for that team appears underneath for whichever > column required (sales etc) > > Can this be done and where to start? > > Tom > > > -- > tom300181 > ------------------------------------------------------------------------ > tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580 > View this thread: http://www.excelforum.com/showthread...hreadid=392165 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
or
Data>Filter>Advanced Filter>Copy to another location ? HTH, -- Gary Brown gary_brown@ge_NOSPAM.com If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "tom300181" wrote: > > I have a large sheet (200X200 approx) of individuals that has name, team > and a number of Stats. > > I need some way of moving details of an entire team (10 rows) data to a > different location/sheet. I want to be able to put the team code into a > cell and all of the data for that team appears underneath for whichever > column required (sales etc) > > Can this be done and where to start? > > Tom > > > -- > tom300181 > ------------------------------------------------------------------------ > tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580 > View this thread: http://www.excelforum.com/showthread...hreadid=392165 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Collating information from a custom form | Barry Sion | Microsoft Outlook Form Programming | 1 | 10th Jul 2008 05:55 PM |
| collating information from multiple sources | Trooper | Microsoft Excel Discussion | 1 | 17th Dec 2004 11:16 PM |
| Collating information from Word forms | Sriram | Microsoft Word New Users | 1 | 20th Aug 2004 05:16 PM |
| Outlook Files information Location, and Registry information | Iwi | Microsoft Outlook VBA Programming | 0 | 16th Oct 2003 11:06 AM |
| Can't specify location information | levotch | Microsoft Windows 2000 Networking | 1 | 30th Sep 2003 09:52 PM |
