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
 
Top