2 Replies Latest reply on Jun 22, 2012 8:35 AM by Jonathan Anderson

    Combining 2 worksheets from 2 different data source

    Jonathan Anderson

      HI Everyone:

      I have 2 worksheets that I have built with 2 different data sources.  One has my results and is from a SQL Database Extract and the second has the Expected results from an Excel spreadsheet.   

       

      I would like to combine them into one sheet to be able to view the actual on top of the expected.  I have thought of putting the Expected into the SQL DB and unionning them together but the results can be filtered by date range and I don't think that there is a way to ensure that the Expected is within that Date Range. 

       

      The other problem is that this is for multiple product types that are also age specific.

       

      If anyone has any suggestions I am open to trying anything.

       

      thanks

      Jon