Channel: TeachExcel

Category: Education

Tags: search a workbook in excelsearch and replace macrovba to update a valuevba to search a workbookmacros to search a workbook

Description: Full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_JDh6badZmPU 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! To build even more powerful VBA projects or further customize this one, checkout my full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_2_JDh6badZmPU #msexcel #vba #tutorial