You need to create a logic for the number of months to be identified for each version. Once that is done you will have to push the numbers from the source month to the target months by Using PREVIOUS function and Finally you can import the numbers.
Thank you so much for the reply. Sorry @SriNitya is on leave and could not reply. We have tried this in our POC model and it has worked very well.
If you can help us with another step to automate this
Instead of manually selecting which month will be used for budget/forecast for all 12 months, we would like to create a module and to select the month which will be used and it will get copied. any suggestions to achieve this?
Re: Copy data from one month of Current Year to all the months of Future Year
Apologies for the late reply. I need more clarification on the requirement before I can answer. Is the request that you want the selection of the months to be formula based so you do not need to manually set it?