VBA编程与函数的应用

Application of VBA programming and function——Jiang Shihong & Zhang Jun &Huang Qiuhong

日常工作中有一些统计报告,其数据主要来源于清单,需要进行相关汇总及状态呈现。通常使用的手工统计、汇总比较繁琐,且极易出错。比较容易操作、快速得到数据统计结果的方法是:组合使用Visual Basic for Applications(V BA)编程与函数应用。

There are some statistics daily work report, a list of its main sources of data, the need for relevant summary and status presented; commonly used hand statistics, summary cumbersome and error-prone; relatively easy to operate, fast way to get statistical results are ： Combined use VBA programming and function application;