Find Jobs
Hire Freelancers

Need an Excel expert to help find and replace multiple items at once with specific rules in a large excel file

$10-30 USD

Terminado
Publicado hace alrededor de 7 años

$10-30 USD

Pagado a la entrega
I’m looking for an Excel expert who can explain how to do this. I will pay for your time to explain how this can be done with Excel (I'm on a Mac using version Excel 2011). I have a very large list with multiple columns that I need to find and replaces multiple items throughout. Here is the explanation of what I need done. I have 2 sheets in Excel. Sheet1 and Sheet2. Compare column A in Sheet1 to columns A through E in Sheet2. If there is a Match, in columns A through E in Sheet2, then replace each of the matches in A through E in Sheet2 with column B from Sheet1. (the match must be exact and include the entire cell content, not a partial match - capitalization does NOT matter. The part that matters is that the cell is an exact match. I would also like each of the changes to be turned red, so that I know there was a change made) Attached is an example of what I’m looking to do. Please check out the attached Excel file to see an example of Sheet1 and Sheet2. “Final Sheet3” is how things should look once the find and replaced changes are made. So what I’ll need from you is directions on how to take Sheet1 and Sheet2 and get the final results on Sheet3Final. I need someone who is available now who can write up the directions. If you are an Excel expert, this should be pretty quick to do.
ID del proyecto: 13143880

Información sobre el proyecto

31 propuestas
Proyecto remoto
Activo hace 7 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
hey , i was watching your sheet. i made a formula as per your requirement instantly.i have worked. if you give me this project you will get it abrupt.
$25 USD en 1 día
5,0 (1 comentario)
0,8
0,8
31 freelancers están ofertando un promedio de $31 USD por este trabajo
Avatar del usuario
Dear Employer, I will work any formula, function, calculation, modification, automation. PFA my previous automation works for reference. I have done lot of complex formula building works. You may add me on skype to discuss more: ashish260287 Thanks and Regards, Ashish Singhal
$25 USD en 1 día
5,0 (197 comentarios)
7,7
7,7
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD en 1 día
4,9 (395 comentarios)
7,6
7,6
Avatar del usuario
Hi, I have dealt with Excel macros for Mac OS and can handle the requirement. Should take me a day to complete the macro and deliver after testing. Let me know. Regards, Arul
$100 USD en 2 días
5,0 (173 comentarios)
7,4
7,4
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$20 USD en 1 día
4,9 (248 comentarios)
7,6
7,6
Avatar del usuario
i can do it for you quickly and exactly
$30 USD en 1 día
4,9 (116 comentarios)
7,1
7,1
Avatar del usuario
I shall do using Vlookup formula, it is easy for me. I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$25 USD en 1 día
5,0 (90 comentarios)
6,4
6,4
Avatar del usuario
Hi, I am an Excel expert. This task can be done using a formula. Very simple job for me. Ready to complete/teach now. Regards Ravi
$25 USD en 1 día
5,0 (145 comentarios)
6,4
6,4
Avatar del usuario
Hi, I can write a quick macro for this if you wish. I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD en 1 día
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
Hello, I am proficient with Excel and VBA and I would love to help you with this task. I would make a macro that would do what you require. Please contact me for more information.
$30 USD en 1 día
4,9 (133 comentarios)
5,8
5,8
Avatar del usuario
"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan. 18th February (5)
$23 USD en 1 día
4,8 (125 comentarios)
6,1
6,1
Avatar del usuario
Pleasure to help you. I completed project like this. Feel free to message me to start the job. Thank you so much.
$30 USD en 1 día
4,8 (71 comentarios)
5,5
5,5
Avatar del usuario
I can explain you right now.I am working as a design engineer and I have experience of preparing calculation in excel sheet.I have good knowledge of excel.
$20 USD en 0 día
4,8 (12 comentarios)
5,0
5,0
Avatar del usuario
Hello, I have read your job description and I think you can rely on me. I am MS word and excel expert with typing speed of 50wpm. My main strength is the ability of completing any project before the deadline. Sincerely, Farhana
$25 USD en 2 días
4,8 (11 comentarios)
3,6
3,6
Avatar del usuario
Hi. I am interested in your project and know how to do it. I am available now. Please chat me. Thank you.
$25 USD en 1 día
5,0 (9 comentarios)
2,6
2,6
Avatar del usuario
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$25 USD en 1 día
4,2 (10 comentarios)
3,3
3,3
Avatar del usuario
I am a professional any language translator and i have 2 years experience in the all language translates,, befour sometime i was worked on the up-work and a good data entry worker
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This can be done with a piece of macro and formula using the vlookup formula in excel. i can provide you the formula in the sample excel and you can just drag the same to complete you work.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am an electrical and electronic engineering student who has completed BEng degree level . I have lots of experience in engineering mathematics. I also have special skill in working with assembly, MATLAB, Proteus, etc. and my knowledge help me to design electronic circuits I have lots of experience of working under electrical, electronic and mechanical engineers. I will do my best !!! My skills are, Data Entry Copy writing Web search Data Processing Assembly MATLAB Proteus My skills will greatly benefit your jobs. Thank you !!!
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Stewartsville, United States
5,0
143
Forma de pago verificada
Miembro desde jul 16, 2009

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.