Find Jobs
Hire Freelancers

excel and vba programming

€250-750 EUR

Tamamlandı
İlan edilme: 4 yıldan fazla önce

€250-750 EUR

Teslimde ödenir
I have a finance spreadsheet that feeds manually form the banking account. Each record is them cathegorised in many criterias which ultimately forces me to split an entry into multiple entries each with its own combination of categories. This has led to a massive denormalized table that's hard to process and work with. Now I want help to split this table into a master table (with only the bank records) and a details table (containing all the splitted cathegorised records) . I want to automate the navigation from one view to the other (kind of "Edit record details..."). Both views must be editable in excell spreadsheet view
Proje No: 23395139

Proje hakkında

54 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 4 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Hello there, I am an Excel expert and I can do automate macro for you to split your bank transaction. I think it will take 3 days to complete and we can start now. Please send me a message, we can start with sample file. Thank you.
€264 EUR 3 gün içinde
5,0 (210 değerlendirme)
6,5
6,5
54 freelancer bu proje için ortalama €421 EUR teklif veriyor
Kullanıcı Avatarı
Dear Employer, I understand that you need to normalize a data set automatically which you are doing right now manually and then link it to different data sets. Please share the sheet and let me know the exact details. I will 200 percent do your job. I have been doing these jobs since 12 years now. Please check my previous reviews once!! Thanks and Regards, Ash
€300 EUR 3 gün içinde
5,0 (216 değerlendirme)
7,9
7,9
Kullanıcı Avatarı
Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in long term relationships and thus works upto client satisfaction to have them as my clients forever after. I have reviewed your job and ready to proceed to it and will wait for your response to discuss the further details and start the project. Warm Regards Ali
€500 EUR 2 gün içinde
4,9 (159 değerlendirme)
7,9
7,9
Kullanıcı Avatarı
Hello, I can help you in excel VBA project. I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€750 EUR 7 gün içinde
4,9 (385 değerlendirme)
8,1
8,1
Kullanıcı Avatarı
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will manipulate your data (normalize it). I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you 300€* and can deliver within a couple of days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 350 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
€300 EUR 2 gün içinde
4,9 (290 değerlendirme)
7,7
7,7
Kullanıcı Avatarı
Hello Sir Im excel VBA macro and formula Expert :) i can help you to split your table into a master table (with only the bank records) and a details table (containing all the splitted cathegorised records). please ping me now for discuss detail waiting your reply Thank you Galih
€500 EUR 14 gün içinde
4,9 (391 değerlendirme)
7,3
7,3
Kullanıcı Avatarı
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can automate what you need and display the information in a more practical and useful way for decision making. Contact me to discuss the details. Best regards
€285 EUR 3 gün içinde
4,9 (289 değerlendirme)
7,2
7,2
Kullanıcı Avatarı
Hi, I already built some modules for accounting. The modules enable to type actual/forecast transactions in one sheet or to upload external files (like CSV files from banks). At the end of the process, the module produces TB GL BS P&L and cash flow by month/years. The module records the VAT directly to the VAT accounts and also record commissions/exchange rate to relevant accounts where the amount including commission. let me know if you have other types of transaction that you want to split and I will add it to the module. Also, The module manages the forecast by recurrence method About Me: 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. 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.
€500 EUR 7 gün içinde
4,9 (91 değerlendirme)
7,2
7,2
Kullanıcı Avatarı
Hi, I have read the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.
€250 EUR 1 gün içinde
5,0 (251 değerlendirme)
6,7
6,7
Kullanıcı Avatarı
Hi, Would you like to see a quick demo of your masters table and details table formed from your records before you award the project? You can consider it professionally done. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
€500 EUR 5 gün içinde
4,9 (59 değerlendirme)
6,5
6,5
Kullanıcı Avatarı
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
€500 EUR 7 gün içinde
4,7 (80 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
€ 250 Only ------- BBA, MBA in Accounting & Finance ------ Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* Ratting ------ I can make you a VBA program which will make your data categorized absolutely as you want by just clicking on a dedicated button. ------ I can start right now, please message me to discuss more.
€250 EUR 1 gün içinde
5,0 (194 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
Hello, I am Luis and I will be glad to assist you with your project. I have experience with Excel and Visual Basic. I can help you to upgrade your current Excel tool to the next level. Please contact me by chat then we could discuss further details about your project. Kind regards, Luis Romero
€300 EUR 10 gün içinde
5,0 (148 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
I think I am a good fit for this project job because I have all the qualities that you are looking for. Experience is the golden factor with this type of project and I have a minimum of 9+ years of working experience in all of the categories that you need assistance with. I not only meet, but exceed all of the requirements for this project. When I looked at your job requirements for the very first time, it took me no time to realize that I have finished many projects which are similar to yours. I love turning raw data into story-boarded reports that provide actionable insights to executives, or communicate complex data in a simple way to other audiences. I have done few tens of successful projects in Excel,MACROS,VBA, Data Cleaning, Data Extraction, Data Mining, Tableau, Machine Learning, python and more. I do take pride in the satisfaction of my Clients with the work done for them.
€600 EUR 5 gün içinde
4,9 (21 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm ready to discuss for better solution directly in Excel or via Ms Access app with Excel automation. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
€500 EUR 7 gün içinde
4,7 (34 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of splitting or consolidating excel data and Creating Reports. I have done mostly Excel VBA Programming jobs. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
€250 EUR 3 gün içinde
4,8 (103 değerlendirme)
5,9
5,9
Kullanıcı Avatarı
Hello, I am an Australian-based software developer with significant experience in developing custom Financial Solutions in VBA. I have built my own automated workbooks for managing Share Portfolio, Bank Accounts and Investment Properties. I am also well versed at creating easy-to-use User Interfaces and will create a simple and effective method to navigate between your tables. Should you want to discuss this project any further, please reach out via Private Message.
€333 EUR 5 gün içinde
5,0 (26 değerlendirme)
5,6
5,6
Kullanıcı Avatarı
Hi, I have very good experience with XL handling bank statements and categorising them to make good analysis. I can help. Regards. Reuben
€500 EUR 7 gün içinde
5,0 (19 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hi Good Day! Please let me help you to complete this work. I am from Philippines and we experienced a volcanic eruption last weekend please help us through this work. Please consider my bid. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. Please consider my bid. I am also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
€300 EUR 4 gün içinde
4,9 (52 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hi sir, I am interested in your project and offer my services. I am skilled in Excel, VBA, database designing and software development. I can give you best solution within budget and timeline. Looking forward.
€500 EUR 7 gün içinde
5,0 (8 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA and Excel. It will be quick and accurate. If interested, we can discuss this further on chat.
€250 EUR 1 gün içinde
4,5 (20 değerlendirme)
4,4
4,4

Müşteri hakkında

   PORTUGAL bayrağı
Lisboa, Portugal
5,0
3
Ödeme yöntemi onaylandı
Oca 15, 2020 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.