Teejicus
New Member
I'm sorting out my supplier KPI documents for 2016 and currently on their overview tab they have a YTD section showing their monthly scores for each metric of the year so far, and on the right of that is a "Current Month" section that just shows the latest month's scores. (for reasons that are too long to go into I need both sections even though the current month side is redudant)
At the minute they have to manually copy and paste the latest scores from the YTD section into the Current Month section. I thought I'd be clever and try to automate that bit for them with a nested if statement in the current month side that would pick up the latest score and display it - but my wits seem to have abandoned me and all I'm getting is a blank cell.
I've attached a rough example of what I'm trying to do - has anyone got any ideas?
Thanks in advance!
At the minute they have to manually copy and paste the latest scores from the YTD section into the Current Month section. I thought I'd be clever and try to automate that bit for them with a nested if statement in the current month side that would pick up the latest score and display it - but my wits seem to have abandoned me and all I'm getting is a blank cell.
I've attached a rough example of what I'm trying to do - has anyone got any ideas?
Thanks in advance!