Write some Software
This project was awarded to ksriniravi for £40 GBP.Get free quotes for a project like this
Project Budget£20 - £250 GBP
I want to add some macros to a sreadsheet where I manage loans on various worksheets
1. I am trying to list all future payments on deals that are current or under offer and therefore about to be current.
In the following worksheets, from those with "LIVE" or "UNDER OFFER" in B5 extract all details of Date, Payment and Client name from E11..G111 where Payment is Not Zero and populate starting A2 on this sheet
Sort by Date, earliest first
Delete rows where date is before TODAY(). Maybe it is easier only to extract these??
2. I want a forecast of the next 6 months cashflows. Search all worksheets
Populate F2..K2 on this sheet with sums of payments by month by adding payments in each month. Extract from the list on the left.
3. I want to track the history of loans offered from March 15 when we started, so this date is fixed
Populate F6..AZ6 on this worksheet by looking up B3 on each worksheet, summing D1 for each month
File will be sent to winning bidder, but will be a shortened file where only 4 or 5 worksheets are included with false details. I can then add correct worksheets later.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online