Advanced Find, Replace or Update in VBA & Macros for Excel

A robust system for coding a macro (VBA) to search through an entire workbook, match a value based on 1 or more checks, and then update a value or replace a value.

This is a system or framework and not just a single-purpose macro because I show you where and how you can update this and change it to do basically anything you need to do once you find a match in the workbook.

With this system, you can:
- Search an entire workbook.
- Search any number of Tables or Worksheets.
- Match a single value.
- Match multiple values across multiple columns.
- Update or replace any number of cells once a match is made.
- Update, expand, and change this framework to work for almost any situation where a Find/Replace/Update is required.

Sample Advanced Scenario for This System: Search through all of your inventory, locate items for a specific manufacturer which are running low, generate an order and export it as a PDF, automatically create an email and attach the PDF to it and send the email - this can be done all with the click of a single button!

Here you learn the framework that allows you to do this and, with my Full VBA Course, you will learn how to do so so much more!

#msexcel #vba #tutorial

[wayneedmondson]

Nice one! Thanks for demonstrating. Thumbs up!!

[sherzafariqbal]

Such a great tutorial dear.
Bundle of thanks DUD😇

[Awptimal]

Great tutorial. can you enter a wildcard value?

[jugalshah]

What can i do if multiple and different values we need to change in workbook?

[teoxengineer]

Very good. Thank you.
Have you any video about using find function in VBA?

[kalyanireddy]

From a set of given days how to find consequent dates, and select the first date of the consequent dates range? Please help

[hazemzenhom]

i need to to replace many cells at one time but replacing is depending on many cells change every time i want to replace ... what can i do ??!

[mikeramirez]

Your example data did not include "Yes" in all of the rows where the number was less than 7. What went wrong? Or did I misunderstand what you were doing?

[mapa]

Thank you for your video, BUT it's annoying that you're saying all the time that there's so much more in your videos that you're not teaching here