Collating information in a different location

  • Thread starter Thread starter tom300181
  • Start date Start date
T

tom300181

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 :confused:
 
Thanks for the response. I'm afraid that auto filters etc will not wor
as I need to move the data to a different sheet.

Anybody got any ideas on this one?

Thanks

To
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Delete entire rows by selecting different text in column A 2
Let User Select Sheet to Pull Data From 7
Impossible task? 2
Count if and Vlookup using a lookupsheet 3
How do I get totals from several different worksheets on to one? 1
Soccer stat spreadsheet help 1
#n/a drving me mad, need to force ignore or remove them - Help! 5
Filtered Data into Charts 1

Back
Top