In my workbook, my first tab is where all my data is. It has company names
and the industry that they belong to. I need to make a different tab for
each industry. What is the easiest way to pull only the companies in the
Auto industry to the Auto tab, the Telecom companies to the Telecom tab
etc????? I dont just want to copy the data sheet and then just run the
auto filter since it will be too large of a file and take forever to
save/open.

Thanks