Find Jobs
Hire Freelancers

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

€30-250 EUR

Em Andamento
Publicado há mais de 10 anos

€30-250 EUR

Pago na entrega
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!
ID do Projeto: 5181463

Sobre o projeto

31 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
31 freelancers estão ofertando em média €83 EUR for esse trabalho
Avatar do Usuário
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 em 0 dia
4,8 (262 avaliações)
7,7
7,7
Avatar do Usuário
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 em 7 dias
4,9 (139 avaliações)
6,4
6,4
Avatar do Usuário
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 em 3 dias
4,8 (8 avaliações)
5,5
5,5
Avatar do Usuário
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 em 10 dias
4,6 (52 avaliações)
5,2
5,2
Avatar do Usuário
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 em 0 dia
5,0 (16 avaliações)
4,9
4,9
Avatar do Usuário
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 em 3 dias
4,9 (17 avaliações)
4,8
4,8
Avatar do Usuário
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 em 3 dias
5,0 (8 avaliações)
4,7
4,7
Avatar do Usuário
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 em 2 dias
4,9 (20 avaliações)
4,5
4,5
Avatar do Usuário
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 em 1 dia
4,9 (14 avaliações)
4,4
4,4
Avatar do Usuário
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 em 2 dias
4,7 (20 avaliações)
4,1
4,1
Avatar do Usuário
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 em 3 dias
4,9 (10 avaliações)
3,5
3,5
Avatar do Usuário
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 em 3 dias
4,6 (10 avaliações)
3,1
3,1
Avatar do Usuário
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 em 3 dias
5,0 (4 avaliações)
2,9
2,9
Avatar do Usuário
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 em 3 dias
4,3 (4 avaliações)
2,7
2,7
Avatar do Usuário
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 em 3 dias
5,0 (4 avaliações)
2,5
2,5
Avatar do Usuário
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 em 1 dia
4,6 (1 avaliação)
1,5
1,5
Avatar do Usuário
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
€40 EUR em 3 dias
5,0 (2 avaliações)
0,0
0,0
Avatar do Usuário
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 em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) GERMANY
Stadtlohn, Germany
5,0
5
Método de pagamento verificado
Membro desde out. 1, 2012

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.