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