Excel vba macro
- or -
Post a project like this4056
$$
- Posted:
- Proposals: 4
- Remote
- #218583
- Awarded
Description
Experience Level: Intermediate
I want to make 3 changes to code
1) If you look at 60 + delinquent workbook
Denmark fmb structure and fmc structure is missing below fma in top 5 + dq loan
means
output should look like
DENMARK MHC FM QPR2001 CON LA 1270 8 31 R
DENMARK MHC FM QPR2001 CON LA 1270 9 32 JATINDER
DENMARK MHC FM QPR2001 CON LA 1270 10 33 JATIN
DENMARK MHC FM-A PCC-2003-1 CON LA 670 6 29 RAN
DENMARK MHC FM-A PCC-2003-1 CON LA 670 7 30 RA
DENMARK MHC FM-B PCC2003-1 CON LA 670 6 29 RAN
DENMARK MHC FM-B PCC2003-1 CON LA 670 7 30 RA
DENMARK MHC FM-C PCC2003 -1 CON LA 670 6 29 RAN
DENMARK MHC FM-C PCC2003 -1 CON LA 670 7 30 RA
The one marked in yellow are missing and please note they lie in different loan structure that is fma and fmb
2) sofiltel = 900 as it is reported once
whereas see family 666 fifth avenue it is reported 8 times and its current balance = 130+130+120+120+130+130+120+120= 1000
and it should come before Sofitel as it is more than Sofitel
666 avenue is reported in 2 deals if you notice WB AND GE STILL IT IS PART of one family so family is given priority over deal in terms of current balance but deal is used to lookup portfolio worksheet and report cusip.portfolio and market value and different loan structure are also to be reported
I am not able to see the code I suppose after completion of payment I would be able to see please look into this
There are arrow buttons in each tab coloured yellow (these are top 5 reports) once click it works out the report for you.
Green tabs where the calculations are made so no manual input.
Black tabs where you put raw data as you receive.
and instead of copy pasting the 60+ delinquent ,portfolio,liquidation in final workbook all these are input file that are copied pasted to final workbook and then calculation is performed on these file I want to call these file from a folder and automate the whole process instead of manually copy paste the input file in final workbook.
1) If you look at 60 + delinquent workbook
Denmark fmb structure and fmc structure is missing below fma in top 5 + dq loan
means
output should look like
DENMARK MHC FM QPR2001 CON LA 1270 8 31 R
DENMARK MHC FM QPR2001 CON LA 1270 9 32 JATINDER
DENMARK MHC FM QPR2001 CON LA 1270 10 33 JATIN
DENMARK MHC FM-A PCC-2003-1 CON LA 670 6 29 RAN
DENMARK MHC FM-A PCC-2003-1 CON LA 670 7 30 RA
DENMARK MHC FM-B PCC2003-1 CON LA 670 6 29 RAN
DENMARK MHC FM-B PCC2003-1 CON LA 670 7 30 RA
DENMARK MHC FM-C PCC2003 -1 CON LA 670 6 29 RAN
DENMARK MHC FM-C PCC2003 -1 CON LA 670 7 30 RA
The one marked in yellow are missing and please note they lie in different loan structure that is fma and fmb
2) sofiltel = 900 as it is reported once
whereas see family 666 fifth avenue it is reported 8 times and its current balance = 130+130+120+120+130+130+120+120= 1000
and it should come before Sofitel as it is more than Sofitel
666 avenue is reported in 2 deals if you notice WB AND GE STILL IT IS PART of one family so family is given priority over deal in terms of current balance but deal is used to lookup portfolio worksheet and report cusip.portfolio and market value and different loan structure are also to be reported
I am not able to see the code I suppose after completion of payment I would be able to see please look into this
There are arrow buttons in each tab coloured yellow (these are top 5 reports) once click it works out the report for you.
Green tabs where the calculations are made so no manual input.
Black tabs where you put raw data as you receive.
and instead of copy pasting the 60+ delinquent ,portfolio,liquidation in final workbook all these are input file that are copied pasted to final workbook and then calculation is performed on these file I want to call these file from a folder and automate the whole process instead of manually copy paste the input file in final workbook.
Vijendra R.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
100%
Last project
13 May 2024
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies