Chapter 94
Recording macros
Questions answered in this chapter:
How do I record a macro?
How do I record a macro that applies a desired format to any range of cells?
How do I run a macro?
How do I use relative references to record macros?
Each week I get sales data that gives the weekly sales of my company’s products during the last two weeks. Can I use a macro to compute the weekly changes in sales for each product?
I am analyzing lineup data for the Indiana Pacers. After each game I get a spreadsheet that contains the number of minutes each lineup plays in the format 12.23m, representing 12.23 minutes. Can I use a macro to efficiently delete the m from each row?
How can I record a macro that filters a PivotTable to show only data from my ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.
