3 Replies Latest reply: Aug 26, 2011 4:44 PM by Bikash Debnath RSS

    Macro to select data from two separate table

      Hi Friends,

      It's been a long time.

      I recently came up with one situation, that I had to use two different table to bring data into one chart and

      those tables are not connected.


      In table A I have a field called FACT_TYPE(renamed as FACT_TYPE_A) and in table B I have a FACT_TYPE(renamed as FACT_TYPE_B).

      I have attached a sample application, could you please refer to that.


      What I need is a macro code that will select FACT_TYPE value from both table. Otherwise I had to select manually from both tables.


      Many a thanks beforehand,



      Bikash Debnath