Sort info

N

Newbi

Is it possible to sort information containing certain data from one sheet
into other separate sheets/workbooks for that particular data? Ex.. Main
sheet contains all information on baseball teams. I want to sort out the
cubs, put the data on it's own worksheet, and update automatically.
 
O

Otto Moehrbach

Look at "Filter" in help. That will allow you to group all the "cub" data,
then you can copy/paste to the other sheet. HTH Otto
 

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

Dealing with the error: unable to filter on excel hc home school 0
Copy previous record into form field 0
Duplication 2
Pictures in Cells 4
Auto update worksheets 2
How do I link each cell to each worksheet to change as I enter dat 3
Sorting issues 2
Multiple Challenging Excel needs.... 0

Top