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.
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: www.contextures.com/tiptech.html
Subscribe to Contextures RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips #ExcelQuickTips

[@user-kg7np6gx1o]

Fantastic! Best explanation of how to perform this task! Thank you!

[@contextures]

You're welcome, Dennis, and thanks for your lovely comment!

[@ag8276]

been leaning from you since forever. Thank you so much ma'am!

[@contextures]

Thank you so much - I really appreciate hearing that!

[@miladytejeda132]

Pivot table