Chapter 14. Data Manipulation Techniques
In this chapter, we turn away slightly from VBA to examine how we can make the most of Excel's advanced data-manipulation features. Although the user interface is usually the only part of our applications that our users will know (or care) about, it is the quality and efficiency of our data processing that provides the solid foundation on which a great user interface can be built.
Excel provides some extremely powerful data-manipulation features, if used in the correct way. The most difficult aspect of organizing our data processing is often deciding which features to use in each situation, and how they can be efficiently combined.
Excel's Data Structures
Excel's data-handling features fall into two distinct ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
