My goal is to create a table where I can change the Month and have it show my monthly expenses for that month. I would like the headers to stay the same each month and the "Itemized Totals" row to appear for each month. Please see this screenshare video for a more detailed description: https://cl.ly/3o1e1g1W1n2H. I attached a screenshot of the table below - I currently have the month as a drop down. But i would like the table data to change as I change the month. I would appreciate any suggestions! Note this table also feeds into a master spreadsheet where I keep track of all my expenses. (The screenshare video shows all this in a more straightforward way).
What I want to accomplish is in sheet 2. Right now I have the table set up with December at the top and each subsequent month below.
(Dec, Jan, Feb etc.)
Column A which has the month names is a drop down menu from which I can select the months. However what I want to be able to do is have one
central table where I can switch months and have the data change too.
This data also feeds into sheet 1 in the corresponding fields.
I created a video with a demonstration to describe what I want to do here: https://cl.ly/2I0a3Y3L1Q2H. I also attached the file to this post.