Simplify the Loop Statement

[Faridwahidi]

Hi,

Can anyone help me to simplify this code,

Please Login or Register  to view this content.

[MarvinP]

Hi Farid,

How about something like this?

Please Login or Register  to view this content.

[Faridwahidi]

Hi Marvin,

Thanks for willing to help me.

It works but still use long code. I hope to have a simple code because I need to reduce one by one for the subsequent if statement until the last one. Column "SE" until "SY" will represent February to December and it will be reduced until December whereby only "SY" to be tested using if statement.

Here is the description. Every IF statement tested will execute different output.

Please Login or Register  to view this content.

[MarvinP]

Ok then,

Perhaps something like the below where you only need to give the first columns letters and it loops.

Please Login or Register  to view this content.

[Faridwahidi]

Hi MarvinP,

Thanks for giving basic idea. I have found my working code

Please Login or Register  to view this content.