Hi all,
My question is simple but I struggling since this morning to find a way to do it...
Basically in my company we use 13 period a year (not in month as companies usually do).
I'm currently working on an excel that need to be updated each month. I need to automatize the calculation of the YTG/ YTD cells. For the moment I'm just using a simple sum formula (e.g. for YTD I'm doing sum (P3:U3) and Sum(V3:AB:3) for YTG figures) however at each period I need to change the letters in the formula to have the correct data which is annoying with so many lines (full P&L). So I'm wondering if you guys have a way that by entering the period number (comprise between 1 & 13) the YTG & YTD calculations will change depending of the period number.
I hope my question is clear enough but if not don't hesitate to tell me and I'll try to explain it better.
Thanks,
felixmars
My question is simple but I struggling since this morning to find a way to do it...
Basically in my company we use 13 period a year (not in month as companies usually do).
I'm currently working on an excel that need to be updated each month. I need to automatize the calculation of the YTG/ YTD cells. For the moment I'm just using a simple sum formula (e.g. for YTD I'm doing sum (P3:U3) and Sum(V3:AB:3) for YTG figures) however at each period I need to change the letters in the formula to have the correct data which is annoying with so many lines (full P&L). So I'm wondering if you guys have a way that by entering the period number (comprise between 1 & 13) the YTG & YTD calculations will change depending of the period number.
I hope my question is clear enough but if not don't hesitate to tell me and I'll try to explain it better.
Thanks,
felixmars