Find Jobs
Hire Freelancers

create excel macro/vba

$10-30 AUD

Terminado
Publicado hace más de 9 años

$10-30 AUD

Pagado a la entrega
Budget $15 Need someone to create a script in excel (macro) which can take data from multiple files one by one and add to one master file. Tasks: 1. All data contained in multiple slave files must be copied and placed into one Master file which will contain all records consolidated 2. The script will sit inside the created Master file called ‘CombinedData’ 3. Button on Sheet2 called ‘Import Slave Data’ 4. When pressed, all files (except for Master file ‘CombinedData’) in the same directory/ folder as master file will import in 5. Need to only copy data- data remains unchanged in originating slaves 6. Data is processed by one slave at a time, one by one 7. Data is added to Master below existing data row so builds up (should not delete /replace any data in master file) 8. Need to add column ‘File Name’ to column A of Sheet1 for Master file and append the file name for where each record came from for every row added in Master file. This means data from slave will always begin from column B. 9. Need to copy color highlight (important) 10. No need to copy data validation rules. • Admin will ensure format of columns is the same as slave so data is displayed correctly • There are formulas so only values should be copied into master. • The script needs to be versatile so can be used in other scenarios- no hard coding of slave names or full directory name- just whatever is contained in the folder where master file sits it should take.
ID del proyecto: 6690921

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi! I would be pleased to do a project for you again! I can deliver very fast, I have the scripts ready, only have to complete it if you could please answer a couple of questions I have after going through your requirements: 1. Done: are there also subfolders? (If yes: if masterfile is in "C:\SomeFolder\ and path of file in subfolder would be: C:\SomeFolder\SubFolder\, what would you like to put as filename? Only the filename, or also the name of the subfolder?) 2. I will not only ignore "CombinedData", but also the "temporary filenames", e.g. if "[login to view URL]" is open, there is also a temporary filename "~$[login to view URL]". 3. Button on Sheet2 = OK 4+5+6+7+8 = OK 9. What do you mean by copy color highlight? Copy value including formatting (including cell color) = OK 10. If e.g. a cell is bold + red, and bold comes from straight forward formatting and red comes from data validation rule: do you want to copy "bold + red" (= not the [login to view URL] but the [login to view URL]) or only "bold" (= neither the formatting rule nor the formatting value) Many thanks again for your consideration and I look forward to working on this project! I will also send you a message in your inbox to make sure you won't miss my bid between the many other ones... Brgds, MKL7
$15 AUD en 1 día
5,0 (18 comentarios)
3,2
3,2
21 freelancers están ofertando un promedio de $24 AUD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$50 AUD en 1 día
4,9 (251 comentarios)
7,6
7,6
Avatar del usuario
We are ready to work on this project and to start immediately We have the requirements to handle this project effectively and timely too. For this job we will be using our vast experience on excel Macros to handle it,
$34 AUD en 1 día
5,0 (53 comentarios)
6,6
6,6
Avatar del usuario
Hello, I'm Excel and VBA programmer with over 5 year of experience. I have written many different applications for Excel in recent years. I am confident that I can perform this task. I am currently working in a large trading company in Europe. Thank you very much Jan Krzyzak
$14 AUD en 3 días
5,0 (93 comentarios)
6,0
6,0
Avatar del usuario
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$27 AUD en 1 día
4,9 (63 comentarios)
5,7
5,7
Avatar del usuario
Hi, I have experiences with excellent feedback for this type of project, fast work and pay attention to the details. Regards, Jay
$30 AUD en 2 días
5,0 (92 comentarios)
5,8
5,8
Avatar del usuario
Hi; I can help. I am an Excel/Word VBA coder professional with over ten years experience in developing automated productivity enhancing, time saving applications. I can provide many examples on your request. I can have your macro completed today, Your comments and questions are most welcomed. Regards Zenon
$45 AUD en 1 día
4,9 (32 comentarios)
5,6
5,6
Avatar del usuario
Hi, I'm Excel VBA developer and i can develop script for data consolidation ''No Hard Coding**** Thanks
$15 AUD en 1 día
5,0 (10 comentarios)
4,7
4,7
Avatar del usuario
Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$15 AUD en 0 día
5,0 (48 comentarios)
4,6
4,6
Avatar del usuario
i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign
$15 AUD en 1 día
4,9 (26 comentarios)
4,3
4,3
Avatar del usuario
20+ years of experience. Will list file s from folder. open one by one . first do normal copy and then value paste to retrain format from slave.
$15 AUD en 2 días
5,0 (2 comentarios)
3,4
3,4
Avatar del usuario
We are a group of qualified people ever ready to complete your work in time. we are 24 hours ready to finish as soon as possible.
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have already done this kind of job so I can fulfill your requirement easily... Will be happy to work with you..
$20 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, a few information about me - Master of Science in Electrical Engineering - excellent knowledge of Microsoft Office suite, Photoshop, Audacity, Adobe premiere, Adobe Illustrator, Pinnacle studio, QuickTime Pro I have a great experience in MS Office software as well as in VBA for MS Office . Everything is clear from your description and I don't have any questions for now. Best wishes Ivan
$20 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i belong to banking field and use to work on excel.i will ensure you that you will find hardly any mistakes in my work.
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am having experience of more than 14 years in Data entry and have worked on MS office i.e. word, excel and power point. I look ahead associating with you want the clear idea about the work to be done, time frame and payment will be made. I assure you that work will be delivered to you as per pre decided schedule and to your utmost satisfaction. Waiting for your affirmative reply.
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi , I have already some tools that does what you want. I can update it to you need in no time and you can use it when you want.
$40 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Your explanation is written very clearly. In fact I have some additional questions: - in master folder there will be some other files? if yes what types? - all workbooks will be of the same format (Excel 2003/2007, with macros, etc.)? - does SlaveData have headers? do script have to copy them? For every answer I have some ideas. It will be working like hell. This script will be ready in less then couple of hours with 3 days free support. BR, Daniel
$14 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Enmore, Australia
5,0
59
Forma de pago verificada
Miembro desde feb 15, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.