Find Jobs
Hire Freelancers

Excel VBA - compare specific data from multiple

$25-50 USD / hour

Terminado
Publicado hace más de 5 años

$25-50 USD / hour

Construction business and we use Excel to create estimates. When creating estimate for complex projects we often create multiple tabs on same worksheet (create copy of original) to mock up different options for customer. Would like to use VBA to create a 'Comparison' tab which shows the highlighted cells (yellow) for each of the tabs on file. I have attached a very small mockup of actual file
ID del proyecto: 17847438

Información sobre el proyecto

33 propuestas
Proyecto remoto
Activo hace 6 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
Hello! I am Bob and I'm ready to implement the needed comparison tab. Do you mean that only the yellow cells would be displayed on the comparison sheet or they contain the comparison criteria? Why there are repeating values in the 'General Information' column? Is it because this is a mockup? Are you looking to optimize the worksheet structure or you want the macro to work on that exact structure? I can give you some tips about the workflow and the overall layout of the table... Ping me to discuss the details and give you a more accurate estimation of the job length and cost. Thank you for considering my application!
$39 USD en 40 días
5,0 (2 comentarios)
5,4
5,4
33 freelancers están ofertando un promedio de $34 USD /hora por este trabajo
Avatar del usuario
Hello, I have the good knowledge of Excel VBA - compare specific data from multiple. I have more than 5 years of experience in Excel, Visual Basic, Visual Basic for Apps . I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
$30 USD en 40 días
4,9 (393 comentarios)
8,1
8,1
Avatar del usuario
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to develop the VBA code that will automate the process of filling a Comparison sheet which will have highlighted cells. I'm going to spend less than 2-3 days to complete your project including required revisions for a payment of $40/hour . I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$40 USD en 40 días
4,9 (309 comentarios)
7,8
7,8
Avatar del usuario
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio 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
$29 USD en 40 días
4,9 (140 comentarios)
7,5
7,5
Avatar del usuario
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$25 USD en 10 días
4,9 (176 comentarios)
6,5
6,5
Avatar del usuario
Hello Sir, Thanks for the requirements, I can do perform following activities : 1) Date Separation using Excel related functions, ( VLookUp, HLookUp, Conditional Formatting, Text To Column, If etc) 2) Excel VBA Macro Creation 3) Text Pad Macros creation by Regular Expression 4) Manage Excel into proper format. 5) Concatenate data with other tagging excel sheet. 6) Convert Excel data into XML using different macros 7) Checking Data Conversion 8) Check each and every tag by Epsilon tool and publishing tool 9) Web based data collection ( Mazilla and Chome Add-on ) 10) Strong Web research Please message me so we will have some productive discussion on the same. Thank You
$41 USD en 40 días
5,0 (13 comentarios)
6,2
6,2
Avatar del usuario
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, data automation, financial modeling and various other computations, analysis and automation. I will be happy to discuss in detail that how I am highly suitable for this project.
$25 USD en 3 días
4,7 (99 comentarios)
6,1
6,1
Avatar del usuario
Hello there, as an expert in excel and VBA, i can help you to accurately compare and highlight your data as you have specified. Please contact me and let us talk more about your project. Thanks
$25 USD en 10 días
5,0 (83 comentarios)
5,8
5,8
Avatar del usuario
Hello Sir, I read your project description and I am very interested in it I need some more information Can we discuss the project I am waiting your response thank you
$41 USD en 40 días
4,8 (31 comentarios)
5,5
5,5
Avatar del usuario
Hello, This will be a quick job as mentioned in the project description. I can deliver this by tomorrow. Let's discuss over chat. Thanks, Rayyan
$41 USD en 40 días
5,0 (18 comentarios)
4,9
4,9
Avatar del usuario
Hi Sir, This is Gopal. I am an accountant. I have gone through your project description and I am able to do it. I would like to draw your kind attention on few of my excel skills:- Maintaining and organizing data, Data Management, Data Entry. VBA,Formula development, VLOOKUP, HLOOKUP, LOOKUP, IF, INDEX, SUM. Pivot Table Development and Management Process Improvement Develop and implemented standard operating procedures to bridge data gaps and resolve related issues. Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than 5 years. Hence, I have expertise on SAP, Tally ERP9, Quick Books, MYOB, ZOHOBOOKS, XERO, MS Access, MS Word, PowerPoint and MS Excel. Recording daily transaction or Book-keeping, Maintaining Books of Accounts, Reconciliation and finalisation of accounts are major areas of my job profile. Hence, I request you to grant me an opportunity to serve you by executing and finishing the project giving my level best and so that I could establish myself on this platform though I am new at freelancer. Looking forward for your positive response. Thanks
$40 USD en 40 días
5,0 (15 comentarios)
4,7
4,7
Avatar del usuario
Hello I would be able to help with your comparison macro. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I hope to hear back from you soon. Kind regards Steve
$33 USD en 5 días
5,0 (8 comentarios)
4,0
4,0
Avatar del usuario
Hello, my name is Esteban, I'm an industrial engineer. I would like to help you in your project and hope you help me earn my first points!
$25 USD en 40 días
4,9 (27 comentarios)
4,3
4,3
Avatar del usuario
Hi, I have extensive experience of developing Excel VBA macros for the purpose of automating dashboards and reports with overall experience of over 7 years in various MNCs. My passion is to provide quality and timely deliverable to client thus creating client ecstasy. I make it a point to adhere to tight deadlines and submit deliverable with 100% accuracy.
$25 USD en 40 días
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and I have held several senior level positions during my professional career spanning over 15+ years. I have around 5 years of experience handling 8 teams PAN India as a Senior Manager. Besides this, I am an expert in Visual Basic for Applications (VBA - Macros) for automating complex Excel based reports. I am also an expert in data visualization tools like Tableau. I also have developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. I have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). I have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. Thanks & Regards Satish Chandra +91-9999986050
$27 USD en 40 días
4,8 (2 comentarios)
1,6
1,6
Avatar del usuario
Hello, I am quite interested in your job. Let me explain my experience. Over 6 years of experience in Management Information System (MIS) with excellent skills to create dashboards, reports and automate it using scripts. I had good exposure in tools for data analytics, data visualisation, gap analysis and process mapping. Ability to think “out of the box” and propose alternatives to solve problems and have a flexible approach to change and able to work effectively in a variety of situations. Currently based in Johannesburg, South Africa. Expert in Tools:- -Microsoft Excel/Macro/Advance Formula. -Microsoft Power BI. -Microsoft Word. -SQL. If you have any questions about my work, please do not hesitate to ask. Regards Shyamapada Singha
$27 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This project is right up my alley! I have 30+ years in the construction industry and have created many similar databases/spreadsheets for construction projects I am very proficient with excel and I know I can give you exactly what you need. I provide you with constant updates and request/implement your feedback in a timely manner. I am available from 6 am to 8 pm Eastern US time to answer any questions.
$44 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am a finance professional and I live and breathe spreadsheets and VBA. Based on the info provided I should be able to complete the project within 5-10 hours.
$44 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 7+ Years of experience in designing Excel dashboards, templates and VBA Macros. I have designed many projects to communicate with other applications like power point, Access, Internet Explorer and mainframe applications
$41 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I would happy to assist you in all type of designing task with 100% job satisfaction. hey there, I can do the data entry well, I also have the experience, I have some special skills which are as follows, data entry Logo designer Microsoft Office Ms word Ms excel Ms powerpoint photoshop image editing Page maker Content Writing Translation (Hindi and English) photo editing video editing typing data transcription, etc.. i will do this work in minimum time and good accuracy.. please hire me and give a chance to work with you. Thanks & Regards Sourabh Kourav
$50 USD en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Cedar Rapids, United States
5,0
2
Forma de pago verificada
Miembro desde sept 26, 2018

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.