25$ VBA Macro to search for header in table and create Worksheets based on unique values

  • Hi OzGrid Devs,

    $2.5 paid to OZ pp. $25

    I have an excel file with two spreadsheets.

    1. General

    2. Data (a set of values)

    The data comes in various format and the order and number of columns changes frequently, however all column headers are unique.

    I want to specify on the General sheet the header name after which the table has to be filtered.


    Instructions below.

    - Deliverable will be an excel file with macro included, with comments.

    - Field or Element to type in the Value of the column header to filter on.

    - Button Analyze DATA linked with macro

    - When button ("Analyse DATA") is pressed

    -The column with the name (specified in Field above) is searched

    - For each each unique value of this column a new worksheet with that name is created

    -The filtered data for each unique name is copied to there.

    - New Macro subroutine

    -Each table on the new worksheets are transferred into an dynamical table.

    - New Macro subroutine

    -The autofilter is removed from the Data worksheet.

    -From the DATA worksheet a new Pivot Table as a new Worksheet name PI_DATA is created.


    Button "Create Pivot Table" linked with macro

    - When button ("Create Pivot Table ") is pressed

    For all Tables created above as well Pivot Tables are created with the Prefix name PI_


    Once a developer is confident they can help me achieve this goal, I can share the two example files (from where to start and how the results should look like).-

    I already inserted some macros e.g. for file import.


    Regards

    JR


    Thanks!