i have data in EXCEL file "export" like this
| LOB | 31-Dec-17 |
| PFA | 164320 |
| CFL | 239487 |
| MIC | 78511 |
| MIH | 647 |
and in separate other excel file "OF" like this
| line | quarter | PFA |
| 1) | | Paid | Reserve |
| 2) | All Quarters | | |
| 3) | 30-Sep-16 | | |
| 4) | 31-Dec-16 | | |
| 5) | 31-Mar-16 | | |
| 6) | 30-Jun-17 | | |
| 7) | 30-Sep-17 | | |
| 8) | 31-Dec-17 | | |
| | | | |
| | | | |
| | | | |
| line | quarter | CFL |
| 1) | | Paid | Reserve |
| 2) | All Quarters | | |
| 3) | 30-Sep-16 | | |
| 4) | 31-Dec-16 | | |
| 5) | 31-Mar-16 | | |
| 6) | 30-Jun-17 | | |
| 7) | 30-Sep-17 | | |
| 8) | 31-Dec-17 | | |
| | | | |
| | | | |
| line | quarter | MIC |
| 1) | | Paid | Reserve |
| 2) | All Quarters | | |
| 3) | 30-Sep-16 | | |
| 4) | 31-Dec-16 | | |
| 5) | 31-Mar-16 | | |
| 6) | 30-Jun-17 | | |
| 7) | 30-Sep-17 | | |
| 8) | 31-Dec-17 | | |
| | | | |
| | | | |
| line | quarter | MIH |
| 1) | | Paid | Reserve |
| 2) | All Quarters | | |
| 3) | 30-Sep-16 | | |
| 4) | 31-Dec-16 | | |
| 5) | 31-Mar-16 | | |
| 6) | 30-Jun-17 | | |
| 7) | 30-Sep-17 | | |
| 8) | 31-Dec-17 | | |
| | | | |
now i want to transfer data from export file to OF in Reservse in last quarter i.e. 31 Dec 2017 through code how i do this through optimize code
how i do this any idea?
