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.
34 freelanceria on tarjonnut keskimäärin 29 $ tähän työhön
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
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.
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.
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.
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