This is some simple code to either "Reset" a user entry workbook or to clear cell values before / after...
Ms Office
SQL Query Into to VBA Language - The Converter This process will enable to you build a SQL query to...
Conditional Formatting - The basics Quick start! By applying conditional formatting to your data, you can quickly identify variances in...
You can attach this code to a button that can open Internet Explorer and navigate to a set website. Sub...
You can add a Data Validation list based on the value of another cell. For this example, it uses the...
This will allow you to add years,months or days to a date in excel Formula Type =DATE(YEAR(A2)+2,MONTH(A2),DAY(A2)) Years =DATE(YEAR(A3),MONTH(A3)+5,DAY(A3)) Months...