Getting 12 months from any given time

[samiamsz]

I have to write a process that basically gets a month from a user and copies data into a new book from that date and twelve months onward.

Im using a cellgets to get the month I need, But in the cellputN for the period, Im not sure how to do it.

Im assuming i need a variable that takes the user entered Month and adds the next 11 moths to it, But im not sure how to do this. I have worked on rolling months but it wouldnt work here

[Ajay]

1) Are you wanting the 12th month ? if so why don't you use an attribute on the elements which has the 12th month in it ?

or

2) Are you wanting the all the 12 months ? If so why not have a consolidation of the months which you can reference in an attribute from the selected first month ?

HTH
Ajay