Käynnissä

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

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.

Taidot: Excel

Näytä lisää: need help excel, excel data validation select multiple items, excel macro find replace multiple items, excel copy column multiple excel files, need help excel contacts, convert large word file data fields excel format, add multiple users excel file, access large excel file, macro import multiple text files excel file automatically, multilingual excel file multiple languages, excel file large, excel vba import multiple file worksheet, add multiple items osc, vbs replace cells excel, zen cart shipping multiple items help, download excel file vbnet multiple worksheets, replace values excel vbnet, import large excel file multiple worksheets, multiple attributes multiple items oscommerce, help excel, paypal button php class form multiple items, multiple queries excel file, export excel file access database excel vba, importing excel file access database excel vba, data multiple excel file single file

About the Employer:
( 142 reviews ) Stewartsville, United States

Projektin tunnus: #13143880

Myönnetty käyttäjälle:

uzmamani

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 1 päivässä
(0 arvostelua)
0.0

34 freelanceria on tarjonnut keskimäärin 29 $ tähän työhön

deepbluetech

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 2 päivässä
(159 arvostelua)
7.0
Webxpert4u

Hello, I am ready to Compare and work all column. LET'S DISCUSS before starting the task. I would love to work on this task. I can easily do any task in excel for example, creating macros, pivot tables, graph, Lisää

150 $ USD 3 päivässä
(113 arvostelua)
6.8
P0L

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 1 päivässä
(123 arvostelua)
6.4
paris2785

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 y Lisää

20 $ USD 1 päivässä
(94 arvostelua)
6.1
dpune

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. Lisää

30 $ USD 1 päivässä
(102 arvostelua)
6.1
best4best

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 1 päivässä
(114 arvostelua)
6.1
mehedi276

"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 sev Lisää

23 $ USD 1 päivässä
(116 arvostelua)
6.1
vlayausa

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 1 päivässä
(95 arvostelua)
5.5
zebracaro

i can do it for you quickly and exactly

30 $ USD 1 päivässä
(69 arvostelua)
5.5
MohsanEijaz

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 applicati Lisää

25 $ USD 1 päivässä
(37 arvostelua)
4.9
renesontiongson

Pleasure to help you. I completed project like this. Feel free to message me to start the job. Thank you so much.

30 $ USD 1 päivässä
(32 arvostelua)
4.7
nadimvicky

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 0 päivässä
(3 arvostelua)
4.4
asin1987

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 Lisää

25 $ USD 1 päivässä
(4 arvostelua)
3.5
fpopy

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. Sincere Lisää

25 $ USD 2 päivässä
(8 arvostelua)
3.3
romaniaexpert

Hello, i can do this quickly using excel vba macro i think it is 1 hour job i am free now so i can start now waiting your answer Regards

25 $ USD 1 päivässä
(7 arvostelua)
2.7
zhy

Hi. I am interested in your project and know how to do it. I am available now. Please chat me. Thank you.

25 $ USD 1 päivässä
(9 arvostelua)
2.6
thilinajayase199

I am a university student who is following a Master of Electrical Engineering degree. So I think that i will be able to fulfil your desired job since I have done IELTS and I have a good proficiency in English as well a Lisää

10 $ USD 1 päivässä
(1 arvostelu)
1.1
jmabriol

I am a currently working in an School Institution as Administrative Staff/Computer Technician and at the same time College Instructor and I teach Microsoft Excel.

25 $ USD 1 päivässä
(0 arvostelua)
0.0
ajitmohanty1979

I will develop a macro based tool for you. If you want I can give you a customized tool (but it will charge more) where you can refer different columns and sheets as per your need in future

45 $ USD 2 päivässä
(0 arvostelua)
0.0
Afchaakter

Hello, After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’m a professional data entry specialist with 3 years experience. And I’m very intere Lisää

15 $ USD 1 päivässä
(0 arvostelua)
0.0