data transfer through loop

[amber12]

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?

[SamT]

Where do these numbers go? The Dates and sections are obvious, but...

PFA 164320
CFL 239487
MIC 78511
MIH 647

[amber12]

i mentioned these numbers go on OF sheet in reserve column

[SamT]

i mentioned these numbers go on OF sheet in reserve columnI try to save my expensive internet bandwidth.