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

I think your best bet would be to use the Advanced Filter. This filter
allows you to copy data from a master list to many sub-lists based on
the criteria you enter. If you record the process in a macro(s), you
can easily refresh each table as new data is added to the master. To
set up an advanced filter you need three input items - the entire
master range (usually good to name this), the criteria (you can use as
many fields as you need (sounds like you will just need industry here)
and the output range (here you can specify which columns from the
original data you want to pull). Let me know if you need help with
more of the details - I thought this would get you started and wouldn't
get bogged down too much in the nitty-gritty. Later, Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=380074