Hey All,
I am pretty new at this, I wanted to a create a VBA code or an If statement where the code would start with the Inv. Date "10/13/2011" and if the corresponding EOmonth "39385" is less than the Eomonth code "39477,39506,39537" then copy the Amt"8,572.20". However, I would like it to be copied only until the date mentioned in the Cobroker Eomonth Column"39477" so for the first one the amount of 8572.2 should be in Jan 2012 but not Feb 2012. Also, once this ends "Dec 2012" the columns are blank in that case i would like the loop to go to the next row. Please help, I have 5000 line items.
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="3"></colgroup>
I am pretty new at this, I wanted to a create a VBA code or an If statement where the code would start with the Inv. Date "10/13/2011" and if the corresponding EOmonth "39385" is less than the Eomonth code "39477,39506,39537" then copy the Amt"8,572.20". However, I would like it to be copied only until the date mentioned in the Cobroker Eomonth Column"39477" so for the first one the amount of 8572.2 should be in Jan 2012 but not Feb 2012. Also, once this ends "Dec 2012" the columns are blank in that case i would like the loop to go to the next row. Please help, I have 5000 line items.
| Inv. | Co broker invoice date | Inv. | Cobroker | 39477 | 39506 | 39537 | |
| Date | Eomonth | Amount | Eomonth | Jan 2012 | Feb 2012 | Mar 2012 | |
| 10/13/2011 | 1/30/2012 | 39385 | (8,572.20) | 39477 | -8572.2 | ||
| 11/28/2011 | 1/20/2012 | 39415 | (500.00) | 39477 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="3"></colgroup>
