Find Jobs
Hire Freelancers

create an excel VBA to consolidate data from 4 excel files into 1, based on some predefined data dictionary

$12-30 SGD

Terminado
Publicado hace más de 8 años

$12-30 SGD

Pagado a la entrega
create VBA to combine data from 4 excel files into 1. basic features include 1. converting simple dates into year and month columns 2. combine different columns into 1 3. exchange rate conversion based on rates table 4. assign each record with reference table
ID del proyecto: 9166205

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 8 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, Would be my pleasure to help you with the vba code. I have developed many excel apps and have done more than 250 projects in this site with all full 5 stars rated and have a maximum completion rate till date. I am sure I can help you with the requirements you've mentioned. Let me know if you are ready to send me those 4 files and if you have already the template of the combined data. Regards - Daniel
$36 SGD en 1 día
5,0 (193 comentarios)
6,5
6,5
19 freelancers están ofertando un promedio de $39 SGD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$75 SGD en 1 día
4,9 (254 comentarios)
7,7
7,7
Avatar del usuario
A proposal has not yet been provided
$30 SGD en 1 día
4,9 (243 comentarios)
7,0
7,0
Avatar del usuario
Hello, my name is Cristian, i have a degree in Business and owrk with excel everyday. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$30 SGD en 3 días
5,0 (185 comentarios)
6,7
6,7
Avatar del usuario
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$30 SGD en 1 día
5,0 (242 comentarios)
6,3
6,3
Avatar del usuario
i can make a program that will merge multiple excel sheets into one and also populate , lets discuss more thank you
$30 SGD en 3 días
5,0 (44 comentarios)
5,6
5,6
Avatar del usuario
Bis jetzt wurde noch kein Vorschlag eingegeben
$31 SGD en 3 días
5,0 (64 comentarios)
5,7
5,7
Avatar del usuario
Hi, 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. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. 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. I can start working on the project immediately and complete the job within some hours. Regards
$26 SGD en 1 día
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an 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 For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$111 SGD en 1 día
4,7 (29 comentarios)
5,7
5,7
Avatar del usuario
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Virtual Assistance, Web research, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Social media marketing, lead generation, etc. Also i can type as fast as 75WPM with 100% accuracy. Certified in Intuit Quickbooks and handling bookkeeping for 5 Australian & 2 US clients. Expert in VBA, VB, .NET, SQL, MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Assuring you of our best services. Thanks and looking forward to hear from you soon. Have a great day!!!
$30 SGD en 1 día
4,8 (73 comentarios)
5,8
5,8
Avatar del usuario
Hello Thank you for the kind explanation of your requirements. I have read your description and believe I can deliver it perfectly as per your requirement. I can write a macro which shall consolidate the 4 excel files into 1. It shall do all the things you mentioned like, extracting dates to year and month and placing them in different columns. It shall convert rates according to the rate table provided. The script shall combine columns into one. The last instruction needs a bit more clarification: Records being assigned to a reference table. Shall the data be fetched from a reference table? based on what data? Pls explain. This whole process shall be automated by a VBA script as you requirements. It will be great if you can share your source file and a sample template of your desired output so that I can have a better idea how to finally present the result. ... ... ... From my profile you’ll see that I earned a good reputation from clients for the good works provided through the years. All of my completed works have been about using VBA to write macros that manipulate data in various ways and manners. Everyone provided 5/5 feedback. Please let me know if you have any queries or if you want to discuss anything related to the project . I am always happy to discuss any issues. Thank you With best regards Raad
$28 SGD en 1 día
5,0 (33 comentarios)
5,2
5,2
Avatar del usuario
Hi Im an expert in Excel and MS technologies I have been working in banking sw development for the last 20 years Regards Carlos
$36 SGD en 1 día
4,8 (28 comentarios)
4,9
4,9
Avatar del usuario
Hello, I’m programmer/developer. Expert in Excel/VBA/Macro. I can Create one excel file from 4 excel files as your explained. Can you please send me 4 excel files. I want to review? Waiting your reply Regards Kashif
$30 SGD en 3 días
5,0 (29 comentarios)
3,8
3,8
Avatar del usuario
A proposal has not yet been provided
$30 SGD en 1 día
4,8 (8 comentarios)
3,3
3,3
Avatar del usuario
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.
$25 SGD en 3 días
4,2 (5 comentarios)
2,8
2,8

Sobre este cliente

Bandera de SINGAPORE
Singapore, Singapore
5,0
3
Forma de pago verificada
Miembro desde dic 21, 2015

Verificación del cliente

Otros trabajos de este cliente

create infographics
$3-10 SGD / hour
¡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.