Hi all,
I am not very knowledgeable when it comes to the dynamic part of excel but what I am wanting to do is basically have the chart on the tab labeled "visual coverage" based on the pull down menu listed just to the left of the chart which coincides with the day of the week.
The data that I am pulling this info from is on the same page but to the right starting in column AA.
The Sunday info is correct and I would like it to stay in that format but change with the day of the week when the menu is pulled down.
Any help would be greatly appreciated! I'll wait up to see if we can knock this thing out tonight!
Workbook attached.New Store Schedule.xlsx