Increase Amount in Multiple Cells - Excel Macro Demo
Quickly add the same amount to values in multiple cells, manually or with a macro.
For example, select a group of date cells, and increase by 1 week, by adding 7 to each cell.
You can add amounts manually, with the Paste Special command.
Or, use the macros from my sample file, to save time.
-- Macro 1 adds a specific number to selected cells.
-- Macro 2 prompts you to enter a number, then adds that amount to selected cells.
Watch this video to see the manual steps, and a quick demo of the two macros.
Visit my Contextures site to download the Excel sample file, and for the written steps.
https://www.contextures.com/exceladdn...
Video Timeline
00:00 Introduction
00:26 Manually Add Number
00:59 Macro 1: Add Specific Number
01:38 Macro 2: Prompt for Number
02:00 Get the Sample File
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: https://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips #ExcelQuickTips