H Folks, I have 3sheets of excel in which 1st is Account Details as well Loan type(starting Loan date, emi dates, ending date, Loan against Asset, Asset Value, Sanctioned Loan Amount, ROI, Credit Ratings etc). In 2nd Sheet , Poolid{1,2,...20}as Variables and Monthwise interest rate for e.g., first month 0.69% 2nd Month 0.79%...o.1% will be increased value in the subsequent months interest rates till 360 Months. In 3rd Sheet , LGD{Poolid(1,2,..20) as Columns and Years(1,2,...10) as rows . The problem is as follows:- a)LGD table has to be........ For each Poolid's 10 observations has to come corresponding to their values. b)Poolid table has to be For each Poolid's 360 observations has to come corresponding to their month and values. As of now nothing to do with Account Details . The problem is to create 3 DATASETs and in last append. Thanks in advance for reply... Regards, Dil0424_KS
... View more