Hi. Today’s video will show you how to delete rows of data based on cell errors across worksheets. As we can see, some of the…

Goal: A macro to allow Excel users to dynamically update a change source data range in a Pivot Table. This tutorial will explore one way…

Goal: To convert all formula cells contained in a workbook to their cell values using an Excel macro. This presentation will show you how to…

This feature will present a macro approach to unfreeze selected worksheets. Currently Excel only allows users to unfreeze panes one worksheet at a time.

Goal: Permit Excel users to unfreeze panes across selected worksheets in an active workbook.

Our macro will insert and fill down rows of data simultaneously in a spreadsheet. This is useful where a financial model contains missing rows of data.

Goal: Enable users to insert and fill down multiple rows of data simultaneously in a spreadsheet.

This video will show you a macro-based solution to freeze selected worksheets in a workbook. As we presented in an earlier video (https://youtu.be/yyM2_KecErA), Excel will only allow a user to freeze panes in one worksheet at a time.

Goal: Allow Excel users to freeze panes in the same position, across selected worksheets in an active workbook.