amber12
05-01-2018, 10:29 AM
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
9) Paid Reserve
10)All Quarters
11)30-Sep-16
12)31-Dec-16
13)31-Mar-16
14)30-Jun-17
15)30-Sep-17
16)31-Dec-17
line quarter MIC
17) Paid Reserve
18)All Quarters
19)30-Sep-16
20)31-Dec-16
21)31-Mar-16
22)30-Jun-17
23)30-Sep-17
24)31-Dec-17
line quarter MIH
25) Paid Reserve
26)All Quarters
27)30-Sep-16
28)31-Dec-16
29)31-Mar-16
30)30-Jun-17
31)30-Sep-17
32)31-Dec-17
now i want to transfer data from export file to OF in Reserve in last quarter i.e. 31 Dec 2017 through code how i do this through optimize code
how i do this any idea?
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
9) Paid Reserve
10)All Quarters
11)30-Sep-16
12)31-Dec-16
13)31-Mar-16
14)30-Jun-17
15)30-Sep-17
16)31-Dec-17
line quarter MIC
17) Paid Reserve
18)All Quarters
19)30-Sep-16
20)31-Dec-16
21)31-Mar-16
22)30-Jun-17
23)30-Sep-17
24)31-Dec-17
line quarter MIH
25) Paid Reserve
26)All Quarters
27)30-Sep-16
28)31-Dec-16
29)31-Mar-16
30)30-Jun-17
31)30-Sep-17
32)31-Dec-17
now i want to transfer data from export file to OF in Reserve in last quarter i.e. 31 Dec 2017 through code how i do this through optimize code
how i do this any idea?