Find Jobs
Hire Freelancers

Makro for Excel 2013, Change several files in folder and merge to one table

€30-250 EUR

Sürüyor
İlan edilme: 10 yıldan fazla önce

€30-250 EUR

Teslimde ödenir
We have the following task: Working in Windows (XP, 7, Vista) with Excel 2010-2013 Looking for a Macro or VBA App which does the following: - A folder contains several Excel files. Each one with one sheet containing up to est. 100 lines max - Each line can contain text and a small drawing - There must be an additional column inserted in each File - This column must have a simple calculation (=Bn*$J$5) and a Top description like in the sample - The files must be merged to a new table - The table contains the first 7 lines of one file (No matter which one) - all following merged files must have the first 7 Lines be deleted I attach 3 sample files ([login to view URL], [login to view URL], [login to view URL]" for the process and one final result "[login to view URL]" file. It is important that the layout remains the same!
Proje No: 5181463

Proje hakkında

31 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 10 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
31 freelancer bu proje için ortalama €83 EUR teklif veriyor
Kullanıcı Avatarı
Hi, I will be happy to help you set up that macro and I can start right away. It should not take more than an hour once the requirement is clear
€42 EUR 0 gün içinde
4,8 (262 değerlendirme)
7,7
7,7
Kullanıcı Avatarı
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
€155 EUR 7 gün içinde
4,9 (139 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
Hi, This is Amit from India. Expert in excel macro development and creating excel based apps. We have created various management systems in excel along with systems like quotation generation tool,an invoice system,file manager,timesheets etc. We believe in doing a clean business & understand that a good & quick support from development team is something that helps customer gain maximum benefit out of a system. Our bid is $122 in 2 days of timeline. Looking forward to hear from you soon, Thanks, Amit
€122 EUR 3 gün içinde
4,8 (8 değerlendirme)
5,5
5,5
Kullanıcı Avatarı
I am conversant with Excel and have many Macros for different purposes. You project is fairly simple,it is to merge the data in different files after deleting the the first 7 lines in the 2nd and following files. I shall assume that the number of such files is not known and the macro should come to stop when the all the files have been merged. the number of lines in each file is also not known aand selection of lines for merging should stop when a blank line is encountered. Also I assume that the macro can pick up any one of the sample files and append data from other files. An Excel Macro to undertake these tasks can definitely be made. Even if there are changes in the rqquirement,then even these can be accomodated.
€34 EUR 10 gün içinde
4,6 (52 değerlendirme)
5,2
5,2
Kullanıcı Avatarı
Hello! This is a job I can deliver within two hours after you hire me. I have years of experience with Excel and I guarantee you will be satisfied with my work. Best regards, Tom
€39 EUR 0 gün içinde
5,0 (16 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. During our contract I will be available via Skype/Gtalk, email and via site message center. All of these messages are forwarded to my cell phone so you can rest assured communication will not be a problem. Bugs fixing and minor changes are included in the bid without any additional fees. Best regards, Adrian
€77 EUR 3 gün içinde
4,9 (17 değerlendirme)
4,8
4,8
Kullanıcı Avatarı
Hi, I am a programmer and i can do your work .Please contact me for the same work , Awaiting for your kind response. Thanks
€155 EUR 3 gün içinde
5,0 (8 değerlendirme)
4,7
4,7
Kullanıcı Avatarı
Hi I have done similar macros (consolidation of excel files). Your task looks interesting and i am ready to create macro for you. I see visio images in last column of each sample file - it should be copied too? Regarding additional column that should be added in sample files - is this column C (Gesamt-summe)? I think this can be done in 1-2 days. Regards, Eugene.
€34 EUR 2 gün içinde
4,9 (20 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
EDIT to the bid posted earlier: Hi, I would like to provide you the working sample but it seems I can not initiate a private chat with you. Kindly contact me through the Private message board, and I would be more than happy to provide you with the fully functional file. Thanks & Regards, Himanshu ************************************************************************************************************ Hi, Based on your specifications, I have prepared a Fully Functional excel to do the job. I will post that to you in a few minutes and you can review it. Accept my bid ONLY if it works for you and is close enough to what you want. Since this is for review purpose only, I have put a constraint in my code so that it processes only 3 files at max. I can quickly remove this to make it fully functional if you like it. Posting the file in a couple of minutes, Himanshu
€35 EUR 1 gün içinde
4,9 (14 değerlendirme)
4,4
4,4
Kullanıcı Avatarı
Sir I'm expert on Excel and i have done many project like this . I will give you best quality and design. Looking forward working with you. I'm ready to start now . Thanks
€88 EUR 2 gün içinde
4,7 (20 değerlendirme)
4,1
4,1
Kullanıcı Avatarı
i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
€147 EUR 3 gün içinde
4,9 (10 değerlendirme)
3,5
3,5
Kullanıcı Avatarı
Hi, I have over 8 years of experience working with Excel VBA. My skills include: 1. Reading/writing data from/to excel and other files (text, word, access)-using VBA 2. Adding complicated nested formulas to worksheets using Macros based on conditions entered by user 3. Formatting data (rearranging, splitting, combining, sorting) using macros 4. Making macros that react to user actions 5. Combining different charts (Line, column, candlestick etc) on a single chart 6. Connecting to databases using ADO/ODBC and executing SQL queries. Databases worked on: MySQL, Access, Oracle, Other Excel files 7. Creating rich user interfaces in Excel using various controls (buttons, list/combo boxes, radio buttons etc..) Both, directly on excel worksheets as well as on individual forms. 8. Scraping websites from within Excel VBA 9. Automatically generating charts and pivot tables from VBA No upfront payment is required. The milestone number quoted is because of Freelance requirements. It is optional for you. You don't have to pay. I understand your requirements and would like to take up this project. Please accept my application so we can start the work. thanks & regards
€60 EUR 3 gün içinde
4,6 (10 değerlendirme)
3,1
3,1
Kullanıcı Avatarı
Hello, I completely understand the first part of the job, and that will be possible to do. When it comes to the last part I am not sure what you mean: - The files must be merged to a new table - The table contains the first 7 lines of one file (No matter which one) - all following merged files must have the first 7 Lines be deleted If you are interested I'll would very much like to make a demo for you. Beste Grüsse aus Dänemark
€50 EUR 3 gün içinde
5,0 (4 değerlendirme)
2,9
2,9
Kullanıcı Avatarı
Hello, i am very experienced vb6 / vba macro coding in all Ms. Office Excel/Access/Word/Powerpoint + Vb.net 2005/2013 and will do this excellent quality for you!
€73 EUR 3 gün içinde
4,3 (4 değerlendirme)
2,7
2,7
Kullanıcı Avatarı
Hello would be good a python scripts? If it would fit, i will put an on line demo at str2xls alwaysdata net / merge . Let me know
€122 EUR 3 gün içinde
5,0 (4 değerlendirme)
2,5
2,5
Kullanıcı Avatarı
Hi jocamel, i have read your requirement and see attached files and i can show you one project which i done before like your project. Can i do your project ? If you need i can show you demo about Macro Excel, i ensure i can complete your project within 1 day. Give me chance i will give you result ASAP, hope working with you once time.
€34 EUR 1 gün içinde
4,6 (1 değerlendirme)
1,5
1,5
Kullanıcı Avatarı
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
€40 EUR 3 gün içinde
5,0 (2 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, I did macro coding for your project.. Its now working very fine in Office 2013 and 2010 as well. You can even expect more services from me.. Thanks
€277 EUR 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Piece of cake. I have already made a sample macro to test the idea. Shouldn't be a problem at all. Thanks for considering me. Tom
€34 EUR 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I have 10+ years of experience working as Database Administrator/ Architect experiencing in Project Designing, Management& Implementation. Various solutions will be available with different requirements. so will choose and present you the best available/possible solution as per your business requirements. After you get satisfied, it will be implemented.
€155 EUR 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   GERMANY bayrağı
Stadtlohn, Germany
5,0
5
Ödeme yöntemi onaylandı
Eki 1, 2012 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.