Adjusting an existing Excel Sheet

已完成已发布的 Dec 8, 2015 货到付款

€30-250 EUR

货到付款

已完成货到付款

Existing excel file is creating different documents like invoices, offers, reminders. This can be selected in sheet "Input" C26.

The file has different sheets.

There is a sheet "Formular" where i can create a document like an invoice.

In this sheet there is a button "Rechnung buchen".

Here i need additional function:

When clicking on "Rechnung buchen" right now it should create next invoice number.

NEW: I would also like that the system adds all inputs in related journal sheet when clicking on this button.

If document is invoice then it should be moved into invoice journal.

Each document should have its own journal sheet. invoice journal, offer journal,.....

This journals should contain all data to print out the invoice a second time.

The journals data should not use relations to the other sheets. In case text in other sheets are changing

it should not have any affect on the journal.

I will also need a function in journal for printing out the invoice.

Second:

i should have a statistic sheet.

In this sheet i would like to be able to select a Month and the journal type (e.g. invoice journal).

When selecting invoice journal and selecting a month month i should get a table of all invoices within the selected month.

I would like to see:

"Rechnung-Nr." = Invoice Number

"Datum" = Date of invoice

Name of customer

Company name

"Kunden-Nr." = customer-number

"Summe vor Mwst" = total without tax

"Zzgl. Mwst.(in%)" = total amount of tax

"Gesamtbetrag" = total with tax

Attached you will find excel file

Excel

项目ID： #9078317

关于项目

12个方案远程项目活跃的Dec 9, 2015

想要赚钱吗？

在Freelancer上竞标的好处

设置你的预算和时间表

通过工作获取报酬

大致描述您的提案

免费注册并竞标工作

授予：

dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Wai 更多

€60 EUR 在3天内

(83条评论)

6.0

有12名威客正在参与此工作的竞标，均价€127/小时

jubair7

Let's discuss more and finalize the project and cost. We have our own workplace with 7+ working PCs and laptops, with ~15mbps internet connections. And we never out re-source our projects that we have taken from our cl 更多

€300 EUR 在7天内

(77条评论)

6.6

raghav1101

Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent) with 5 years of experience in the field of accounts and finance. I have 8 years of experience in Microsoft Excel includi 更多

€168 EUR 在2天内

(67条评论)

6.0

P0L

A proposal has not yet been provided

€200 EUR 在3天内

(58条评论)

5.7

mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed se 更多

€147 EUR 在3天内

(45条评论)

5.5

SBITServices

A proposal has not yet been provided

€84 EUR 在3天内

(43条评论)

5.6

nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details 更多

€77 EUR 在5天内

(58条评论)

5.7

Vlzinch

Guten Morgen! I work with excel and access for last 5 years and have created hundreds of different macros, scripts, including different data analitycs tools ,DashBoards and Userforms. I can create the journals and 更多

€147 EUR 在3天内

(24条评论)

5.7

shehroz77

I have a long experience with databases and data entry, i am also very efficient at typing, I also have several qualification in microsoft office suite which include Excel, Word, Powerpoint, Outlook. Well that's all fr 更多

€111 EUR 在5天内

(5条评论)

3.0

zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc 更多

€155 EUR 在3天内

(2条评论)

3.1

akifniazi90

Expert in advance excel functions. I've gone through your requirements and I'm confident that I can create a custom sheet that is perfect as per your requirements. Looking forward to hearing from you to discuss it fu 更多

€50 EUR 在2天内

(1条评论)

1.0

pmullappilly

Hi, I would like to do this work. Because of some bad experiences from some of the clients from freelancer,I would like to take up and complete the work with the following steps: 1)Share your requirement specificati 更多

€30 EUR 在10天内