I have a "database" in one sheet of an excel workbook. Specifically I have roughly 130 columns, each of which contains a unique value for each row. I.E. each row contains an "entry", with the different quantities of that entry recorded in the columns.
One of these columns gives the entry name. For ease lets say these are people, e.g. "Alex, Damien and Danesh". However each person may have multiples entries (rows).
What I want is a way to display certain columns only of all entries for one person only, in a different format, in a different sheet (lets call this Sheet2).
Here's the especially tricky bit, I want to set this up in such a way as to have the entries in Sheet2 change if new names are added, e.g. say at some point "Clarissa" also has entries in the database.
I'm currently considering different ways to do this, but have yet to find one that looks best. I'm keen to avoid VBA as this workbook already has a few scripts, and it will eventually be handed over to someone who can't program, so my manager wants as few macros as possible.
So in summary the question is this:
How do I copy into another worksheet, all entries corresponding to a particular name, noting that (a) the number of names may change and (b) there is a different number of entries per name?
For reference I am using Excel 2010.
Thanks in advance.