Home

data transfer through loop macro

New Contributor

 

i have data in EXCEL file "export" like this 

 

LOB31-Dec-17
PFA164320
CFL239487
MIC78511
MIH647

 

and in separate other excel file "OF"  like this 

 

linequarterPFA
1) PaidReserve
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  
    
    
    
linequarterCFL
1) PaidReserve
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  
    
    
linequarterMIC
1) PaidReserve
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  
    
    
linequarterMIH
1) PaidReserve
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?

            

 

 

Related Conversations
What data does Microsoft collect?
Tim_Gent in Microsoft Teams on
1 Replies
History and Data
rosenbloomsnka in Microsoft To Do on
1 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies