Organizing Daily Data Into Months

[camstout15]

I have a spreadsheet that is meant to track the sales, variance, and labor each day and calculate this percentage as a month. I would like to create a button that will navigate through the months of the year, displaying each day with the data intact.

[/URL][/IMG]
As seen in the picture, each day has data associated with it. After February is over, we will no longer need to look at the data, but will like to keep it stored for later calculation or to look back in time if necessary. Is there a way I can add a button that will switch from displaying February to March, then April, and so on?

 

[baitmaster]

welcome to the board

I can't see your image, for some reason it doesn't display on my machine

As a first suggestion, take a look at pivot tables. You'd simply list all your data on one worksheet, then have a pivot perform the summary somewhere else

 

[camstout15]

Thank you for replying. I'll definitely have to look more into pivot tables and learn more about how they work. I uploaded the picture to Google Drive in case you still wanted to see the data. However, I'm sure the answer will probably be the same: redesign the table as a pivot table. Once again, thank you for your help! https://drive.google.com/file/d/0B8F0N8SW3I56cmMxRGlIYU83Xzg/view?usp=sharing

 

[camstout15]

Thanks to @baitmaster, I have learned how to use a pivot table to group my data by months. However, I would like the table to be a little more interactive. It would be nice if I had two arrows or a drop-down list that would let me navigate by month and day. In this way, upon clicking the arrow the columns which are displaying the month of February will instead show the month of March. If I need to go back and look at the month of February, I could by using an arrow or some other method.

 

[baitmaster]

You should be able to do this with a Pivot which is why I suggested it even though I don't personally like them that much...

Set month as a filter, it should appear as a drop down above your pivot table