Closed

Liquidity plan with Excel VBA

This project was awarded to Tablassus for €40 EUR.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
€30 - €250 EUR
Total Bids
8
Project Description

Hello,

we would like to generate a liquiditypan based on 2 excel files. One file is source file in CSV format, with all data like offer, invoice, sales confirmation, delivery note and price. This is coming daily from our ERP system. The data from there should be integrated in a liquidity plan forcaste Excel spreadsheet, roughly with the following criteria:

- items with "Auftragsbestätigung" in one column data in another column will be taken, insert in a tab in the liquidity plan Excel file and certain cells will flow in pre defined lines in the plan
- itmes with "Bestellung" in one column data in another column will be taken, insert in another tab in the liquidity plan Excel file and certain cells will flow in pre defined lines in the plan
- itmes with "invoice" in one column data in another column will be taken, insert in another tab in the liquidity plan Excel file and certain cells will flow in pre defined lines in the plan

The source file is always same name and same place also the target file. The Makro can be executed manually in the target file (Liquidity plan).

Pls find attached a sample target file and source file the data. the source file has yellow columns, when in the second column one of the red highlighted items appears. Depending on the red item, they will flow in different tabs in the liquidity plan also depending on the date, the total sum will flow in another tab.

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