Hello,
I am currently working on a calendar-like document where I track weekly data, but I only send a recap showing the previous 2 week's worth of data. I have the data saved for several week's but since I only communicate out the previous 2 week's worth of data, I end up doing a lot of copying and pasting. I feel like what I am doing could be done a lot more efficiently. That way if it is requested to look at Week 1 and Week 8, I don't have to go and copy/paste a lot of data, I could just select for my document to only show Week 1 and Week 8.
I would like to have a drop-down list in a cell in the first column to let me choose what week I am referencing. Once a week is selected, it would pull in the information and populate the results for that week - Sunday's data through Saturday's data. The week's data would be in the columns to the right. The part I am unsure about is that the data populated for each individual day has several pieces of data.
To make it easier to understand, I came up with a document (attached below) that will show what I am looking to have displayed.
I know how to create a drop-down list in Excel. But I don't know how to get the drop down choice selected to have such a huge affect on other cells. I know that there will have to be a table created on a different sheet that has all this information, however I am not even sure of the correct way to put this information into a table to get this to work. What I would like to do is if I choose "week 1" from a drop down menu, I would like it to properly change Sunday's date to January 1st, Monday's date to January 2nd, etc. And then under Sunday, display all the information for Sunday, January 1st.
Please let me know if this doesn't quite make sense! And thanks in advance for any help!
Bookmarks