Excel Tutorial

How To Import Filtered Excel Rows From One Excel File To Another Dynamically

This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them …

How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »

How To Create Error Message Pop-Up Alert When User Input Wrong Data In Excel

Some times you may want to verify user input data type or value in excel cell. And excel just provide such feature for you to customize the cell data validation process. You can define which data type and what data value are valid for one or multiple excel cell. If the data is not valid, …

How To Create Error Message Pop-Up Alert When User Input Wrong Data In Excel Read More »