Hello experts,
I need your help again on something that should be easier to do. However, it could also be more complex than it seems.
Form to complete.PNG
As you can see from the above form, I would like to write (paste) the value from boxes coloured in yellow, red and green to the list below
3 command boxes.
I have not written any code yet for this purpose and the coloured picture is done as an example without code.
I assume it is some sort of concatenate function but I get stuck to how to convert the month into numbers and how to make sure the year corresponds to the month of the fiscal year, as per the example, July 2017 but Jan. 2018 although the financial year box only display the year to which the fiscal year ends.
Can anyone help please?
Thank you ever so much.
Bookmarks