Closed

Write some Software

This project was awarded to ksriniravi for £40 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
£20 - £250 GBP
Total Bids
13
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online