Part III

One-Touch Data Manipulation

Check out www.dummies.com/extras/excelmacros for a nifty trick that enables your clients to sort columns by simply double-clicking.

In this part …

• Go beyond basic macros and look at some advanced techniques for navigating ranges through with VBA.
• See how macros can automate the selection and manipulation of specific cells.
• Explore how you can use macros to clean and transform the data in your workbooks.
• Uncover techniques that can help you automate the data exports.