Find Jobs
Hire Freelancers

Cross Excel databases

€30-250 EUR

クローズ
投稿日: 7年以上前

€30-250 EUR

完了時にお支払い
I need to automate manual processes. It is about cross Excel databases including: - I have about 10 spreadsheet and I must have all the information in one. Now I work on the main spreadsheet filling the information included in the other ones. - Find and delete duplicates: with the same unique ID and also fulfilling different conditions (ex. same date, same ID card) - Complete information between databases. I have information with an unique ID in the different spreadsheets and must be filled in the main spreadsheet. - Create extra rows in the main database if the ID is found in one of the spreadsheet - Create some fields based on conditions (ex. if 'the field first buy'='no' and the field 'fidelity card='yes' create a column with the value of the customer, in this case 'VIP customer''). This is now a manual process and I have to do it monthly, so I need to automate (with a macro?) inserting the updated spreadsheets every month. Must be done in Excel or Access because it's the software I have avaliable. Also want to know if it's possible to do a Dashboard with some of the results.
プロジェクト ID: 11315309

プロジェクトについて

48個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に48人のフリーランサーが、平均€154 EURで入札しています
ユーザーアバター
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
€100 EUR 1日以内
4.9 (548 レビュー)
8.5
8.5
ユーザーアバター
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€250 EUR 5日以内
5.0 (501 レビュー)
8.0
8.0
ユーザーアバター
A proposal has not yet been provided
€150 EUR 3日以内
5.0 (496 レビュー)
7.8
7.8
ユーザーアバター
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
€200 EUR 4日以内
5.0 (328 レビュー)
7.5
7.5
ユーザーアバター
Hello, dear sir (or miss)! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, Excel, of course, familiar. But I am confident that Access will be a better choice than Excel. Give me a chance to show what I can do!
€34 EUR 1日以内
4.9 (258 レビュー)
7.1
7.1
ユーザーアバター
Hi there. Yes it is also possible to create a dashboard as well as automation features. We can write the necessary VBA macros and also use the native functions to automatically transfer the data to other sheets. As being one of the most famous Excel expert in this platform, I can work on your job right away. I am mostly online. Lets discuss more on chat.
€225 EUR 3日以内
5.0 (143 レビュー)
7.3
7.3
ユーザーアバター
Greetings Hiring Manager! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH , I have spent at least "200 HOURS" on automation in Excel. I can show you some of my work if you can IM me using chat window (Freelancers cannot initiate a chat with Employers on their own - otherwise I would have shared some of my work myself). I can get your work completed to your complete satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
€90 EUR 3日以内
5.0 (248 レビュー)
7.1
7.1
ユーザーアバター
Hi, I intend to do this using MS Excel. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
€150 EUR 7日以内
5.0 (193 レビュー)
6.9
6.9
ユーザーアバター
Hi sir, I am highly skilled in Excel and VBA and I can automate the whole mentioned process for you on a click of a button. I have done same work before a few times. Please discuss. Thank you. Usman
€200 EUR 3日以内
5.0 (77 レビュー)
7.0
7.0
ユーザーアバター
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
€147 EUR 3日以内
4.7 (91 レビュー)
7.3
7.3
ユーザーアバター
Hey, Going by the description you shared, yes this can certainly be automated using Excel macros. I am an expert in writing automation processes using Excel and have been highly rated for for the excellent quality work I have done for more than 500 projects here on freelancer. Can you share some sample files and the rules you use to combine these files as of now? Based on this information, I would be able to make the process that will do all this in a few minutes. Also, if you tell me the kind of dashboard that needs to be created based on this data, I would be able to create it as well. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps Look forward to hear from you and thank you for considering my bid Best Regards, Rishi (Automyze Consulting)
€222 EUR 5日以内
4.9 (101 レビュー)
6.6
6.6
ユーザーアバター
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 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
€150 EUR 3日以内
4.9 (123 レビュー)
6.3
6.3
ユーザーアバター
Hi, I have read your project description in detail and would like to take an opportunity to work on it. Based on your requirement, I would suggest you to go ahead with MS Access as there you can have forms for data maintenance, interactive dashboard and reports what you want to add. Apart from that it is easy to filter out data based on duplicate and other criteria and whole process can be full automated and you will just need to operate some buttons on forms to get your results. You can just be assured on the efficient results and on time delivery. To have a look on existing data and discuss in detail, I would like to have discussion over chat. Waiting for your response on the same. Thanks, Vimal Arora
€111 EUR 7日以内
4.7 (158 レビュー)
6.2
6.2
ユーザーアバター
I have very good expertise in Excel macros and automation. I can get the data from the multiple sheets consolidated into one sheet based on the certain criteria you wanted to get them together. I have done similar consolidation, merging, validation of data, formulas, lookups, indexes, matches in Excel. Can get started.... My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
€75 EUR 3日以内
4.6 (51 レビュー)
6.1
6.1
ユーザーアバター
hello I am a java developer i can automate all the processes you mentioned there and create you a simple interface using javafx believe me its more interessting than working on excel spreedsheets you will have a menu to add delete data and also to display the rows thanks and i hope to work with you
€155 EUR 3日以内
4.8 (27 レビュー)
5.0
5.0
ユーザーアバター
Hello I am working with MS-Access database and VBA for the past 14 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your project specification. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
€55 EUR 3日以内
4.8 (33 レビュー)
4.7
4.7
ユーザーアバター
Hi I am an expert with excel and further reading your description I am sure I can assist u automate the process. Contact me over chat for further details Itay
€140 EUR 2日以内
5.0 (12 レビュー)
4.2
4.2
ユーザーアバター
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA
€150 EUR 5日以内
4.8 (17 レビュー)
4.4
4.4
ユーザーアバター
Dear Sir, I have experience in website data entry other task easily and having ability to give back to you fine results. I am a graduate of Bachelor of Business Administration (Operation Management). I can complete the job. Hope so you will hire me for this position for better results. Looking forward to work with you. Thanks, Kent Alvin
€155 EUR 3日以内
5.0 (9 レビュー)
3.9
3.9
ユーザーアバター
Hi There! I am a professional software and database developer and i want to work on your project. i can make you a very simple c# application that will make the whole process automatic. i have done such work so many times in the past for different clients so Message me so i can tell you how i will be able to complete it.
€100 EUR 3日以内
5.0 (6 レビュー)
3.9
3.9

クライアントについて

SPAINのフラグ
Spain
0.0
0
メンバー登録日:8月 19, 2016

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。