Posts by antonioroques

    Re: Consolidate Several Crosstabs into single flat table


    SOLVED! Thanks. The problem I had is that I was using the second sheet with one less row field.


    Best Regards,


    For anybody interested in the final version is this one. I also attached the file as an example.


    Thanks for your help MrRedli


    Re: Consolidate Several Crosstabs into single flat table


    Quote from MrRedli;770818

    hope this helps:



    Ok you are a genius, thanks! I only need a little more help, I tried to convert your code to work with multiple sheets, but when change to the second sheet its all messing. This is the code I used.



    I uploaded a screenshot of the result
    [ATTACH=CONFIG]69132[/ATTACH]
    Your help is appreciated..

    Hi, I have a worksheet with 90 crosstabs, I'm trying to merge all of them into a consolidated flat table. Researching I found the attached code made by a member named Norie. The example was made for only one crosstab, so I made some changes to allow it to work for all sheets in a workbook. It worked fine, but I have a problem, my crosstabs have 3 row fields and the code was written for a crosstable with only one column field. I dont know how to fix it.


    I'm attaching the original code, my modified code, the original crosstab and my crosstab.



    Help is appreciated