I have almost finished a project I am working on, but now need a little help, please.
I am preparing a budget by month for 3 different centres.
I have 2 reporting sheets, 1) By Centre and Month & 2) Consoildated and Month
I am stuck for the YTD for both Centre and Consolidated. I need the YTD to show figure from Jan - Nov (If chosen month is Nov).
I have attached a sample worksheet (of a much larger one).
I appreiciate I may not have set out the data as efficiently as I might, but I could not think of another way.
I look forward to hearing possible solutions.