Archive: VBA - Please Fix this VBA code to work for me

Budget 33$ per month

Posted: 5 years ago

Closed

Description: 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.
Skills:
microsoft windows 10,software development,VBA programming language,Visual Basic programming language,web,workbook