Sort info
 

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.

Sort info
 

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
"Newbi" wrote in message
...
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.