Find Jobs
Hire Freelancers

Erstellen Sie ein Excel Macro

€30-250 EUR

Completato
Pubblicato più di 5 anni fa

€30-250 EUR

Pagato al completamento
Build an Excel Macro that generates from file “trinkreif Bestandsliste NEU DD-MM-YYYY” the File “trinkreif Gesamtpreisliste DD-MM-YYYY” and saves it in the same directory as excel file. The file “trinkreif Bestandsliste NEU DD-MM-YYYY” is the existing. There we want to start the macro. The file “trinkreif Bestandsliste NEU DD-MM-YYYY” uses only positive values in column R. The marcro should start with the filtered fields of “trinkreif Bestandsliste NEU DD-MM-YYYY”. So we can filter the rows first and then start the marco and from there we get the according list. The header in “trinkreif Gesamtpreisliste DD-MM-YYYY” (rows 1 – 13) always stay the same. Except 5E – there should be the actual date. Columns V, W , X are constant in “trinkreif Gesamtpreisliste DD-MM-YYYY”. They are the order form for our clients. In total “trinkreif Gesamtpreisliste DD-MM-YYYY” is a version where not all rows of “trinkreif Bestandsliste NEU DD-MM-YYYY” are used. Two actual files are attached. “trinkreif Bestandsliste NEU DD-MM-YYYY” is a sample file. With only 10 products. Please consider that normally this file has about 20.000 rows. The other file is our actual price list.
Rif. progetto: 17537493

Info sul progetto

14 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hi, my name is Selim. I read your "Erstellen Sie ein Excel Macro" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
€180 EUR in 3 giorni
4,9 (271 valutazioni)
7,7
7,7
14 freelance hanno fatto un'offerta media di €192 EUR
Avatar dell'utente
Hallo! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to develop a macro that will create a new Excel file based on the template trinkreif Gesamtpreisliste DD-MM-YYYY and filled with all records that are displayed in the trinkreif Gesamtpreisliste Neu DD-MM-YYYY file (after filtering). This is a common task for me and I can deliver today. I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Sincerely, Paris Pallas
€200 EUR in 1 giorno
4,9 (152 valutazioni)
6,7
6,7
Avatar dell'utente
Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have an experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.
€250 EUR in 3 giorni
4,9 (55 valutazioni)
6,5
6,5
Avatar dell'utente
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
€294 EUR in 3 giorni
4,8 (134 valutazioni)
6,2
6,2
Avatar dell'utente
Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Albert to bid on your project. I believe we can help you with your Excel Macro because I do have a team and are mostly my cousins/close friends that is why we have been working as a good team with trust. I can assign someone who fits your project requirement. My business is to make your business effective, profitable & efficient. We are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring knowledge and new ideas to them. I am a pioneer in the outsourcing/call center industry in the Philippines, and as such, have a deep understanding of world-class customer service, prompt delivery of jobs & the importance of client satisfaction of our work. The team is led by me–a forward-thinking, resourceful professional with more than 13 yrs of experience in Sales, Marketing & Customer Service; who understands the power of good relationships with customers/clients, and that this is the foundation of a successful business & attracts repeat sales. We are highly-skilled, well-educated, English-speaking, smart professionals ready to deliver results for you. Been working on different projects since 2014, with most of my clients are from here (you can check the good reviews we garner on my profile). Willing to discuss.
€250 EUR in 5 giorni
5,0 (20 valutazioni)
6,2
6,2
Avatar dell'utente
Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I could produce exactly what you are looking for and I have highly confident that i can do it with quality & accuracy that's all. Thanks so much! Shafaqat Ali
€141 EUR in 3 giorni
4,9 (94 valutazioni)
5,7
5,7
Avatar dell'utente
HI, I have excellent experience in C#, Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been executing projects for Microsoft as a customer across various technologies like DotNet, SQL Server, SSIS, SSRS. have executed many turn key projects for them in their licensing space which is very critical for them. Will be able to leverage this experience to deliver this project successfully. If you can provide more details about the work then will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy
€105 EUR in 3 giorni
5,0 (15 valutazioni)
5,2
5,2
Avatar dell'utente
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
€164 EUR in 3 giorni
4,9 (50 valutazioni)
5,3
5,3
Avatar dell'utente
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. "Passionate with excel automation"
€180 EUR in 3 giorni
4,9 (24 valutazioni)
4,7
4,7
Avatar dell'utente
Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am very proficient in VBA, Macros and Excel dashboards. My business and financial background is also a perfect fit for your work. Please come to chat to discuss further. I have the experience in supporting many businesses in supporting many activities with o% errors. I can do this work satisfying your business requirements. Look forward to discussing with you of the opportunity further. Kind regards, Dilip.
€250 EUR in 7 giorni
5,0 (12 valutazioni)
4,0
4,0
Avatar dell'utente
Hi - I had a look at the files, they look almost similar to me, except for some formatting required. To build a macro for this is no big deal, but we need to discuss the specifics. I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple excel with formulas to complex power pivots with macros with ease. Having worked for customers like Apple, Microsoft, Boeing, TI for most part of my career I am quite seasoned with professionalism and specificity in term of solutions. Give the task to me and rest assured that you are in safe hands. Regards, Gana
€196 EUR in 3 giorni
4,8 (22 valutazioni)
4,3
4,3
Avatar dell'utente
I am an experienced programmer, using Excel and coding in VBA Excel Macros for more than 20 years. I offer - Quality. Everything organized, excellent grammar, proper indentation comments on the code. - Availability to work full time on this project, to meet the deadline. - Satisfaction guaranteed. - I will start working on this project right away.
€100 EUR in 3 giorni
4,9 (10 valutazioni)
3,1
3,1

Info sul cliente

Bandiera: AUSTRIA
Wien, Austria
5,0
3
Metodo di pagamento verificato
Membro dal mar 29, 2013

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.