none
Query in VBA for excel 2003 RRS feed

  • Question

  • Hello everyone.

    I have two sheets in a excel workbook and in the third sheet I want to get the count of data based on some criteria from both the sheets.

    So i would like to have query for the same using union or so.

    Eg - i have two sheets named "A" and "B" having data in second column with two values -yes/no.

    I sheet "C" i would like to have the total count of data from both sheets, having second column value as "YES".

    So if any one can guide me towards this. Thank you

    • Moved by Mike Feng Friday, March 25, 2011 1:01 PM VBA (From:Visual Basic General)
    Wednesday, March 16, 2011 4:07 PM

All replies