2 Replies Latest reply: Jul 19, 2011 6:49 AM by jaymanson RSS

    Consolidating values in script

      Bit of a noob question - this probably should be really simple, but it's got me stuck!!

       

      As a quick example of my problem, let's say I've loaded Table1:

       

       

      SalesPersonSales
      A10
      B15
      C3
      D8

       

       

      and Table2:

       

       

      RegionSalesPerson
      XA
      XB
      YC
      YD

       

       

      all I want to do in my script is to build a new Table3: that shows this:

       

       

      RegionSales
      X25
      Y11

       

      Obviously easy when using a chart object, but I need to do it all in the script as it's intended to run overnight on a schedule and finish by outputting Table3 to a text file ready to be picked up by another application.

       

      I've not posted the full code as there's a helluva lot more in there, however everything else works fine so no point complicating things - I've just got this little problem to solve which probably comes down to just using the right function!

       

      Thanks in advance for any help!