L
Lesley
I am creating a spreadsheet for management accounts and need to record YTD budget in one colum. I have created a tabl
holding the budget figures for each period and calculating the cumulative budget each period. What I need to be able to do is to access the correct column's YTD budget dependent upon what period it is. Is this a very long series of IF statements, or can I create a macro to do it, or is there a better way? Help needed urgently
Thank
Lesle
holding the budget figures for each period and calculating the cumulative budget each period. What I need to be able to do is to access the correct column's YTD budget dependent upon what period it is. Is this a very long series of IF statements, or can I create a macro to do it, or is there a better way? Help needed urgently
Thank
Lesle