Now you're able to compare data for similar months from several different years. Creating simple macros copy a formula from one cell to another.
Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F.
Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Here’s your choices for wrapping text, adding line breaks and merging cells. For this challenge, we want to be able to compare data for different years side by side. Within our example file, there is A LOT of sales data. To remove the split, click the Split command again.