Chapter 7
Manipulating Data with Macros
In This Chapter
Converting values in a range
Trimming and truncating text
Replacing blanks cells with values
Adding text to existing values
Handling duplicates in a range
Working with AutoFilter drop-downs
When working with information in Excel, you often have to transform the data, cleaning, standardizing, or shaping it in ways that are appropriate for your work. Transforming data can mean anything from cleaning out extra spaces to padding numbers with zeros to filtering data for certain criteria.
This chapter shows you some of the more useful macros you can use to dynamically transform the data in your workbooks. If you like, you can combine these macros into one, running each piece of code in a sequence that essentially automates the scrubbing and shaping of your data.
Copying and Pasting a Range
One of the basic data manipulation skills ...
Get Excel Macros For Dummies 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.
