Deleting rows based on cell values across sheets using VBA
This video is a follow-up to the previous video ( • Deleting rows based on a cell value (update) ), which showed you how to delete zero or blank values.
This demonstration will allow users to delete zero or blank values across multiple, homogenous worksheets of trade data. There will be three worksheets, which will all have the same format and contain some zero or empty cells in column J.
The macro will be called, deleteZeroRowsMultiSheets
Goal: Allow users to delete rows across worksheets based on zero or blank cell values using a macro.