2 Replies Latest reply: Aug 3, 2011 4:55 AM by Miguel Angel Baeyens de Arce RSS

    Macro help required to export data

    Dipesh Patel

      Hello,

       

      How can i run a macro to export all sheetobjects to one sheet in excel workbook (not different sheet)? NOTE: All objects have got same header.

      example objects:

       

      First
      Last
      Count
      ABZ2
      BAY2
      CDX5
      DAW10

       

      FirstLast
      Count
      IAK6
      JKL8
      MOA7
      PS12

       

      So Fianl result on Excel Sheet would be

       

      FirstLast
      Count
      ABZ2
      BAY2
      CDX5
      DAW10
      IAK6
      JKL8
      MOA7
      PS12

       

      Can someone please help me or share a macro?

       

      Thanks,

      Dinesh