VBA - Please Fix this VBA code to work for me
- or -
Post a project like this1868
£25(approx. $31)
- Posted:
- Proposals: 15
- Remote
- #2314648
- Awarded
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
365275257545798984117441649865119279813575931394015144943318894541945791
Description
Experience Level: Entry
I need to delete all occurances of strings listed in sheet A found in sheet B automatically (click a macro).
The code needs to be commented.
This website looks close to the solution I need but I can't get it to work (Excel 2019 / Windows 10) - issue with the sort function being out of range and the GUID not being created.
https://stackoverflow.com/questions/35744094/find-replace-multiple-substrings-from-table-in-excel.
Ideally you can fix this code, or at least use the code to understand what I'm trying to achieve.
Example Workbook provided.
Smaller example
Table A
Orange
Apple
Bannana
Table B
I like Oranges and Apples
I like Bananas and Oranges
I like Coconuts
Result (table C)
I like s and s
I like s and s
I like Coconuts
Please only bid for the work if you can do it, or, better yet, send me a screenshot of your results. I feel that the work specification is clear and does not need further explaination.
The code needs to be commented.
This website looks close to the solution I need but I can't get it to work (Excel 2019 / Windows 10) - issue with the sort function being out of range and the GUID not being created.
https://stackoverflow.com/questions/35744094/find-replace-multiple-substrings-from-table-in-excel.
Ideally you can fix this code, or at least use the code to understand what I'm trying to achieve.
Example Workbook provided.
Smaller example
Table A
Orange
Apple
Bannana
Table B
I like Oranges and Apples
I like Bananas and Oranges
I like Coconuts
Result (table C)
I like s and s
I like s and s
I like Coconuts
Please only bid for the work if you can do it, or, better yet, send me a screenshot of your results. I feel that the work specification is clear and does not need further explaination.
Steven B.
100% (20)Projects Completed
6
Freelancers worked with
7
Projects awarded
73%
Last project
15 Sep 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Steven, in reference of the question I asked earlier in the Clarification Board and the proposal I sent, in my code there is actually the option to choose between running the macro with case sensitive OR case insensitive replacements. I can add a pop-up at the beginning of the macro to prompt user choosing between these two replacement methods.
-
Hi Steven, are you looking for a case sensitive string replacement? (i.e. For replacement keyword "Company", the macro will execute string replacement in "ABC Company" but not in "XYZ company")
773747773725
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies