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.