Managing Data with Microsoft® Excel

Using VBA to Manage Data

This is supposed to be a book about managing data using Excel, so what's a chapter about Visual Basic for Applications (VBA) doing here?

As it happens, the remainder of this book is all about working with VBA. The first six chapters were concerned with the use of Excel's built-in data management capabilities. For example

• The worksheet functions that help you manage data

• The tools that help you filter and sort data

• The ways to populate pivot tables and data ranges

• The methods of importing data from sources such as databases, text files, and the Web

These are powerful techniques and they have broad applicability. For standard situations, they'll serve you very well. You'll have to do some tweaking here and there to get the ...