Separating a Worksheet into multiple worksheets based on column A field.

Hi,

Treat the long worksheet as a database and ensure all the first rows of the columns have unique labels. Name the whole database including labels 'Data'

Now on the various analysis sheets put the column labels (say row 4) that you want to use and name this single row range of labels MySheet!DataOut where 'MySheet' is the name of the sheet.

Now above these column labels create a criteria range which contains the column label of column A of the database in one cell and the value that you want to extract in the cell underneath. Let's assume this criteria range is in A1:A2. Name this range MySheet!ExtCrit

Now add the following macro.

Please Login or Register  to view this content.

Put a button on each sheet and link it to the FilterData macro.

HTH