Find Jobs
Hire Freelancers

Build an Excel scrip

$15-25 USD / hour

Cerrado
Publicado hace más de 4 años

$15-25 USD / hour

We would like to build a scrip that imports a list of fields from an Excel spreadsheet , fills out the Excel spreadsheet, apply the formulas inside the Excel , create tabs for each year with the same formulas and creates a summary tab. Here are the directions: 1. The end user will fill out the “import List” tab 2. The scrip will analyze the data in the "import tab", create a tab for each year (in the example, there are two years: QBAI2010 and QBAI 2011) based on the date of the item. 3. The scrip will pick up the details from the import list and place in the relevant tab based on the year. For example, all of the asset from 2010 will be placed into the QBAI 2010 tab and all of the asset from 2011 will be placed into the QBAI2011 tab 4. Inside the Excel there are all of the formulas that we would like to achieve for each year. The tab QBAI2010 is already fill out with the formals. Please do the same formals for the rest of the tabs: QBAI 2011, QBAI2013-QBAI2018. In other words, QBAI 2010 should be mimic for each year data. 5. The scrip will create a summary based on the Summary tab. I have attached the Excel as an example
ID del proyecto: 20939532

Información sobre el proyecto

32 propuestas
Proyecto remoto
Activo hace 4 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
32 freelancers están ofertando un promedio de $20 USD /hora por este trabajo
Avatar del usuario
Hello, 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
$18 USD en 40 días
4,9 (397 comentarios)
8,1
8,1
Avatar del usuario
Hello. How are you? I have rich experience with Excel SpreadSheet. Please kindly check following my previous works related excel spreadsheet. https://www.freelancer.com.au/projects/php/Project-for-Yanying-20420141/reviews https://www.freelancer.com.au/projects/javascript/Javascript-CSV-files-Jquery/reviews I am a serious bidder and I am very clear what you want. I have reviewed the xlsx file you attached. I hope to work with you because my skill set is suitable for your project. Will wait patiently for your favorable reply. Thank you.
$20 USD en 40 días
4,9 (105 comentarios)
7,9
7,9
Avatar del usuario
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$22 USD en 40 días
4,9 (164 comentarios)
7,7
7,7
Avatar del usuario
Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using diff tools like .NET, Excel and VBA, Winautomation, etc) and I'd like to help you. Please, get in touch to discuss and understand all the details in deep. Based on what we will talk, I'll be able to give you a good proposal. Experience building solutions like: Windows Desktop Apps (using Excel and VBA, Access and VBA, .NET,C++,C#, Winautomation) Scrapers Apps Scrape services Automation programs/bots Web apps/systems. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
$25 USD en 12 días
5,0 (217 comentarios)
7,5
7,5
Avatar del usuario
I'd be happy to help you on this interesting project, and I can also give you a fixed price offer if you prefer to do it that way. Let me know. . .
$22 USD en 20 días
4,8 (269 comentarios)
7,7
7,7
Avatar del usuario
Hi Nice to meet you. I have built so many python scripts for automation works. I checked your attachment. Also checked QBAI tab carefully. No problem to populate with your summary. Let me know more details. Regards Lian
$20 USD en 40 días
4,9 (169 comentarios)
7,2
7,2
Avatar del usuario
Dear client I can write the macro code for you which will solve the purpose. I understand the requirements completely and I ensure the job will be done accurately. I estimate time of completion to be 7-8 working hours. please contact me. Regards Roy
$20 USD en 40 días
4,9 (367 comentarios)
7,0
7,0
Avatar del usuario
Hi there, thanks for the heads up, yes, I can import and update excel fields accordingly. Please reply, we can get started. Thank you.
$15 USD en 4 días
4,8 (251 comentarios)
6,3
6,3
Avatar del usuario
Hi, I have experience in excel working, formulas, macros, pivot, ... please contact me so that we can have a discussion in detail
$20 USD en 40 días
4,6 (16 comentarios)
5,9
5,9
Avatar del usuario
Hello, I am Luis and I will be glad to assist you with your project. I know about Excel and Visual Basic and I can do this project fot you. Please contact me by chat then we could discuss further detials! Luis Romero
$20 USD en 30 días
5,0 (135 comentarios)
5,6
5,6
Avatar del usuario
Hi, nice to meet you. I am database expert in IT company. I am top in database field in my company. I have been working database expert for 8 years. My skill is Python, Mysql, Postgresql, Excel, deep mathematician knowledge. I can implement your project within short time. If you want me, please call me. Best Regards
$15 USD en 40 días
4,9 (43 comentarios)
5,5
5,5
Avatar del usuario
Hello there, You can have these services for your project. -Great Communications -Creative designs -Clean Code by 7+ year experienced expert developer -Dedicated Project Manager -Dedicated Server Manager -Project Analysis and Reporting on time -Follow up after the project completed -Work on reviews by client To know more and further discussion please message me, we are also ready for an interview. Regards, Bharat
$21 USD en 40 días
4,9 (30 comentarios)
5,4
5,4
Avatar del usuario
I can develop a script to analyse the data in import tab and fill the yearly tabs with their respective data along with replicating the formulas from QBAI2010 tab to all year's tab, and also prepare a summary on summary tab. Please find below a brief introduction of myself. I am postgraduate(MBA) in finance with more than 5 years of experience in financial modeling, MIS reporting, advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automated financial models for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$30 USD en 40 días
4,9 (41 comentarios)
5,6
5,6
Avatar del usuario
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 creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$20 USD en 40 días
4,8 (88 comentarios)
5,7
5,7
Avatar del usuario
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$20 USD en 40 días
4,9 (38 comentarios)
5,2
5,2
Avatar del usuario
$ 15 ONLY!!! In Just 2 Hours!! EXCEL VBA MACRO & FORMULA EXPERT <<< 100% satisfaction first, then payment>>>
$15 USD en 2 días
5,0 (95 comentarios)
5,2
5,2
Avatar del usuario
Hi,sir. Thanks for taking your valuable time for reviewing my proposal.I'm a senior developer with over 10 years of experience. I think I can be a candidate for your project. If you can give me your project, I'll do my best to complete it in a short time. I am confident of your project - Build an Excel scrip And I have been very familiar with skills such as Excel, PHP, Visual Basic, Javascript, Software Architecture and so on.
$22 USD en 1 día
4,1 (8 comentarios)
5,5
5,5
Avatar del usuario
Hi Good Day! A serious freelancer here. I've done a lot of work like this one before. I can help you to complete this project with high quality. I really know how to do this. Please consided my bid. 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. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank youl
$15 USD en 20 días
4,9 (41 comentarios)
4,7
4,7
Avatar del usuario
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$20 USD en 40 días
4,7 (17 comentarios)
4,6
4,6
Avatar del usuario
Hi, I have gone through the complete description and i am good at macros, Database and advanced excel with extensive experience of 5+ years which I would consider myself as the best approach for this project. let me if my skills and experience can come in handy for you.
$15 USD en 30 días
5,0 (3 comentarios)
2,1
2,1

Sobre este cliente

Bandera de UNITED STATES
Waldorf, United States
0,0
0
Forma de pago verificada
Miembro desde oct 25, 2011

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.