Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Collating information in a different location
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 |
#3
|
|||
|
|||
or
DataFilterAdvanced FilterCopy to another location ? HTH, -- Gary Brown 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 |
#4
|
|||
|
|||
Thanks for the response. I'm afraid that auto filters etc will not work as I need to move the data to a different sheet. Anybody got any ideas on this one? Thanks Tom -- tom300181 ------------------------------------------------------------------------ tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580 View this thread: http://www.excelforum.com/showthread...hreadid=392165 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Stock Location Sorting Problem | Excel Discussion (Misc queries) | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |