Hi everyone. For the attached workbook, I am trying to use the options in the drop down list in cell B3 to populate the sales table from B6:D19 with the corresponding data listed for that particular week on the "Data" sheet. So, as I change the week that I select from the drop down list, the table will adjust accordingly to the corresponding week in the data sheet.
I didn't fully understand the solutions for previous posts along the same lines and how I could make it work for my workbook. I'm not a very experienced excel user, so I apologize if it's an easy or redundant solution. I really appreciate any advice you can offer. Thank you!
Bookmarks