Select and Display columns from a Table
===

I have a table with Multiple columns which have different types of data.In one of the columns (say A) the data takes one of 7 values which are repeated. For each of these 7 values I want to generate a sub table. Sub table corresponding to one of the seven values in A will contain values from the main table which had that value from column A. Ideally I would like to record a macro when all this is happening so that I can run it every time I do this.