In this tutorial I am going to explain how to copy records to another sheet based on a condition. I explore three methods: Filter and then copy/paste – this method is easiest for beginners Use the FILTER function – this method won’t work in Excel versions prior to Excel 365 Use a VBA macro –… Read More »IF Excel Cell Contains Text Then Copy to Another Sheet | Copy Cell Based on Condition
This tutorial solves a problem where Excel won’t allow you to insert new rows or columns in a worksheet. When you try this, Excel displays the message “Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet. Those non-empty cells might appear empty but have blank values,… Read More »Excel Can’t Insert New Cells Because it Would Push Non-Empty Cells Off the End of the Worksheet
In this tutorial, I am going to look at how to add a zero or multiple zeros in front of a number in Excel. When you want to store a number with a leading zero, it needs to be stored as a text value, as numeric values cannot start with a zero. We will look… Read More »How to Add a Zero In Front of a Number in Excel