Hi, in the attached sheet I would like to have the column R values filled when I select the relevant month in the drop down in Q2 so that each location is shown next to the value for them for that specific month so for example location 1 for January would show £817,991 in the box and location 2 would show £344,747 if I then changed the month to Feb these values would update to show £57,259.37 and £24,132.29 respectively. Can someone help as I have trieda couple of things but not sure how best to do this?
Bookmarks