2 Replies Latest reply: May 15, 2014 10:04 AM by jdino73 _ RSS

    export summaries

    jdino73 _

      I Have 14 summaries in my project that I would like to export. Is there a way that they can be exported into one tab in my excel book instead of 14 diffrent tabs

       

      thank you

        • export summaries
          Olly Bond

          Hello jdino,

           

          Yes, as long as the fields are the same, it's easy to set a project export in Monarch Pro to append the data to the bottom of the existing tab.

           

          If the fields are different, then you can experiment with named ranges, but there are others on this forum with a lot more Excel knowledge who might help you there, or you can consider a multi-stage process and export them to a fixed width text format, open them up again as 14 source report files in a new Monarch project, and build the layout you want there.

           

          Hope this helps,

           

          Olly