Run the Macro
You See? There should be a new Macro Group on the Home
Ribbon. The Add New Rows button should be in this Group.
Try It: Click the Button
22.(the one with the SUM)
Add New Row.
Did It Work? You should see a new Row that includes date,
product name, price and quantity. The formula in the Revenue column
should be there as well.
it Doesn't Work? You may receive a message about Macro security.
save this spreadsheet as a Macro-enabled workbook. Here are the steps:
edit the Macro Security. Here are the step: