Extract/Export records to seperate sheets using criteria

[Ken Frost]

I have a master sheet containg records for many different people - names in
Column 1.

I want to maintain the master sheet by adding, subtracting, changing items
and have these changes reflected on seperate sheets which contain only the
records relating to the one person.

I meed a few pointers to how this is best done and any pitfalls I need to
look out for - can it be automatic ? Do I need macro's or a vba script ?

Any help much appreciated.

Thank you

 

[Frank Kabel]

Hi
if you need an automqatic way you'll probably need VBA. Bu I would
check if an advanced filter is not sufficient for your task