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.