Extracting info to new tables
 

I have a large table of data from which I would like to extract a number of
sub-tables to new worksheets, for instance I would like to have a sheet
showing all entries for a particular module reference. I suppose this is
similar to an advanced filter but using different worksheets. I would also
like the system to be dynamic. If anybody could help me it would be much
appreciated.

Extracting info to new tables
 

One way ..

Try this sample from my archives (full details inside, nicely rendered):
http://savefile.com/files/37091
AutoCopy_data_to_separate_shts_by_key_col_value.xl s

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dazed & Confused" wrote:
I have a large table of data from which I would like to extract a number of
sub-tables to new worksheets, for instance I would like to have a sheet
showing all entries for a particular module reference. I suppose this is
similar to an advanced filter but using different worksheets. I would also
like the system to be dynamic. If anybody could help me it would be much
appreciated.