Dear All,
Apologies for the novice level of skills i have for excel which is the reason im looking to this forum for help.
First i want a suggestion that should i use a macro or not for the below mentioned task.
Now the question is i have a database which looks like
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
Now i want to calculate the status of these accounts on monthly basis by comparing it with the last month status.
If account number delinquency status increased then "FF"
If account number delinquency status decreased then "RB"
If account number delinquency status is same then "STB"
e.g. incase of Feb-11 it should be
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
I have a huge amount of data which means thousands of accounts with years of monthly data.
I am doing it manually by putting in simple IF formula but i wish to make it automated in a vba.
Apologies for the novice level of skills i have for excel which is the reason im looking to this forum for help.
First i want a suggestion that should i use a macro or not for the below mentioned task.
Now the question is i have a database which looks like
Accounts</SPAN> | Jan-11</SPAN> | Feb-11</SPAN> | Mar-11</SPAN> | Apr-11</SPAN> | May-11</SPAN> | June-11</SPAN> | July-11</SPAN> | August-11</SPAN> |
40011300</SPAN> | 0</SPAN> | 1</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 0</SPAN> |
40011313</SPAN> | 8</SPAN> | 8</SPAN> | 8</SPAN> | 0</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 0</SPAN> |
40011326</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | 5</SPAN> | 3</SPAN> |
40011339</SPAN> | 3</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | 9</SPAN> | 10</SPAN> |
40011342</SPAN> | 3</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | 9</SPAN> | 10</SPAN> |
40011355</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011368</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011371</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011384</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011397</SPAN> | 4</SPAN> | 5</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | 9</SPAN> |
40011407</SPAN> | 4</SPAN> | 5</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | 9</SPAN> |
40011410</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 2</SPAN> | 0</SPAN> |
40011423</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> |
40011436</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> |
40011449</SPAN> | 0</SPAN> | 3</SPAN> | 4</SPAN> | 3</SPAN> | 4</SPAN> | 3</SPAN> | 3</SPAN> | 1</SPAN> |
40011452</SPAN> | 0</SPAN> | 1</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 0</SPAN> | 0</SPAN> |
40011465</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011478</SPAN> | 5</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 6</SPAN> | 4</SPAN> | 3</SPAN> | 4</SPAN> |
40011481</SPAN> | 5</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
40011494</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 0</SPAN> | 1</SPAN> |
40011504</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | 5</SPAN> |
40011517</SPAN> | 4</SPAN> | 0</SPAN> | 1</SPAN> | 0</SPAN> | 1</SPAN> | 1</SPAN> | 0</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
Now i want to calculate the status of these accounts on monthly basis by comparing it with the last month status.
If account number delinquency status increased then "FF"
If account number delinquency status decreased then "RB"
If account number delinquency status is same then "STB"
e.g. incase of Feb-11 it should be
Accounts</SPAN> | Jan-11</SPAN> | Feb-11</SPAN> |
40011300</SPAN> | FF</SPAN> | |
40011313</SPAN> | STB</SPAN> | |
40011326</SPAN> | FF</SPAN> | |
40011339</SPAN> | FF</SPAN> | |
40011342</SPAN> | FF</SPAN> | |
40011355</SPAN> | STB</SPAN> | |
40011368</SPAN> | STB</SPAN> | |
40011371</SPAN> | STB</SPAN> | |
40011384</SPAN> | STB</SPAN> | |
40011397</SPAN> | FF</SPAN> | |
40011407</SPAN> | FF</SPAN> | |
40011410</SPAN> | STB</SPAN> | |
40011423</SPAN> | STB</SPAN> | |
40011436</SPAN> | STB</SPAN> | |
40011449</SPAN> | FF</SPAN> | |
40011452</SPAN> | FF</SPAN> | |
40011465</SPAN> | STB</SPAN> | |
40011478</SPAN> | RB</SPAN> | |
40011481</SPAN> | RB</SPAN> | |
40011494</SPAN> | STB</SPAN> | |
40011504</SPAN> | FF</SPAN> | |
40011517</SPAN> | RB</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
I have a huge amount of data which means thousands of accounts with years of monthly data.
I am doing it manually by putting in simple IF formula but i wish to make it automated in a vba.