Liquidity plan with Excel VBA

IN PROGRESS
Bids
8
Avg Bid (EUR)
50
Project Budget (EUR)
€30 - €250

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.

Skills required:
Excel, Visual Basic
Additional Files: sample+Liquiditaetsplanung+IMTI.xls sample+CSV_Export.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire nagybatonyi
€ 95
in 4 days
€ 90
in 4 days
€ 40
in 1 days
€ 52
in 2 days
€ 30
in 5 days
€ 30
in 14 days
€ 30
in 1 days
€ 32
in 5 days