Excel 2016 Macros

Excel 2016

Lesson 3 – Editing Macros

Close the Visual Basic Editor. View the consolidated data in the CITY59.XLSM workbook.

Notice the consolidated value in cell C6 of 10,703 . Open the ATLANTA.XLSX workbook and change cell C7 from 3250 to 9250 . Then, close and save the changes you made to the ATLANTA.XLSX workbook.

Click the Macros button in the Code group on the Developer tab. Run the Urban_Update macro and notice that the consolidated value in cell C6 changes to 16,703 .

Close CITY59.XLSM.

OFFICEPRO, Inc.

Page 55