在VBA中查询excel 2003 [英] Query in VBA for excel 2003

问题描述

大家好。

我在Excel工作簿中有两张工作表，在第三张工作表中，我想根据两张工作表中的某些条件获取数据。

所以我希望使用union来查询相同的内容。

例如 - 我有两张名为"A"的表格。和"B"在第二列中具有两个值的数据-yes / no。

I sheet"C"我希望得到两张纸的数据总数，第二列值为"是"。

所以如果有人可以指导我这一点。谢谢

解决方案

您好，

此论坛区域为通常用于VB.Net问题。

 

对于 VBA 请试试此论坛区域：>>

http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

或ExcelDev区域>>

http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

 

或EXCEL区域答案：>>

http：// 答案 .microsoft.com / zh-CN / office / forum / excel

或上的EXCEL区域social.technet ：>>

http：// social.technet
.microsoft.com /论坛/ en-US / excel / threads

 

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

解决方案

Hi,

This forum area is usually intended for VB.Net questions.

 

For VBA try this forum area please:>>

http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

or the ExcelDev area >>

http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

 

or the EXCEL area on ANSWERS :>>

http://answers .microsoft.com/en-us/office/forum/excel

or the EXCEL area on social.technet :>>

http://social.technet .microsoft.com/Forums/en-US/excel/threads

 

这篇关于在VBA中查询excel 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！