Linking/Lookup

[Guest]

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

 

[cvolkert]

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