In Progress

Liquidity plan with Excel VBA

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: Excel, Visual Basic

See more: pre flow, find in vba, excel vba with, excel vba and, excel 2013 vba, sales plan, sales excel, makro, excel/vba, excel 2013, excel 2013 vba find date, find target sum excel, excel csv tab, sample visual basic excel, Liquidity, liquidity plan, 2013 excel visual basic, excel 2013 visual, daily sales spreadsheet excel, excel vba spreadsheet, liquidity plan excel, excel file columns, excel daily sales items, data vba, find sum excel

About the Employer:
( 22 reviews ) Stockstadt, Germany

Project ID: #4208976

Awarded to:

Tablassus

Dear Sir I have more than 15 years of VBA experience and this is an easy job (converting csv data / allocating data). More info on PM. Best regards Filipe Francisco , VB Expert ============================ More

€40 EUR in 1 day
(10 Reviews)
3.9

8 freelancers are bidding on average €50 for this job

nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

€95 EUR in 4 days
(38 Reviews)
5.3
pierreho

Dear gkmachinetools, I can do it without problem. Best regards

€90 EUR in 4 days
(24 Reviews)
4.8
techism

Sure, Can do very fast. Thanks

€52 EUR in 2 days
(18 Reviews)
3.8
BadihBarakat

+10 years experience in VB / VBA and Microsoft Excel... Please, check the private message...

€30 EUR in 5 days
(2 Reviews)
2.6
epdailo

I have projected 14 days, but it would probably be done in 2. However, I will support you for as long as you need.

€30 EUR in 14 days
(2 Reviews)
2.2
robelbard12

Sir, I read your project details & see your attach file. I can do it. thanks

€32 EUR in 5 days
(0 Reviews)
0.0
Geron

So, you need rows "AUFTRAG" to be copied to "AUFTRAG" sheet (date, customer, payment, payment terms) and so on. Payment have to be split according to payment terms. It is technically simple task, but I need some detail More

€30 EUR in 1 day
(0 Reviews)
0.0