Saving a Workbook When a Specific Cell Is Changed

Sometimes, you may want to save a workbook when a specific cell is changed or range of cells is changed. This macro allows you to define the range of cells that, when changed, forces the workbook to save. Macro Code to Saving a Workbook When a Specific Cell Is Changed Private…

Creating a New Workbook Using Macro

Perhaps you may need to create a new workbook in an automated way. For example, you may want to copy data from a table and paste it into a newly created workbook. The below macro copies a range of cells from the active sheet and pastes the data into a…