Create a New Tab and Setting Up

Step 1

To create a new tab for a new month, simply duplicate the previous month’s tab by right clicking on the tab’s name and select Duplicate.

Step 2

Delete the numbers from the previous month except for the bolded items in the DS DigMS and the ARI DigMS rows. Items in these rows should be left alone because they are formulas adding up numbers in the rows below them.

You can also leave notes (indicated by a red triangle in upper-right corner of the cell) on the Dealer Spike and ARI rows alone, since you will be filling out these items later on. Just remember to clear them out before you begin working to avoid confusion.