Add Auto number in Access Query

Posted on January 2, 2016September 21, 2017 by Wyman W

This Access tutorial explains how to add auto number in Access Query using Access VBA Function. You may also want to read: Sort Data in Access Report Add sorting in Access Table field Add Auto number in Access Table In Microsoft Access, go to Design View of a Table and define the Data Type of a field as AutoNumber Go to data view of the Table, each row of data is assigned a sequence number in ascending order. However, we cannot add the AutoNumber Data Type in Q...

Excel VBA combine worksheets columns into one worksheet

Posted on December 31, 2015September 27, 2017 by Wyman W

This Excel VBA tutorial demonstrates how to combine worksheets columns into one worksheet. You may also want to read: Excel VBA Consolidate worksheets into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel convert data from column to row Excel VBA combine worksheets columns into one worksheet There are two types of combine worksheets Worksheets have the same structures / headers, create a blank worksheet and paste the data from different worksheets dow...

Excel dynamic data range

Posted on December 30, 2015January 3, 2016 by Wyman W

This Excel tutorial explains how to create Excel dynamic data range using Name Range. You may also want to read: Excel dynamic Data Validation list Excel Dynamic Print Area Excel graph dynamic data range Excel dynamic data range The purpose of Excel dynamic data range is to select data range based on how many data you have input instead of using a fixed range. Assume that you have the data set below. You can select A1 to B11 as the data source, but if you do that, you n...

Excel Compare Worksheets using Compare File

Posted on December 25, 2015May 26, 2016 by Wyman W

This Excel tutorial explains how to compare worksheets using Compare File function. You may also want to read: Excel VBA compare worksheets Excel Compare Worksheets using Compare File Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus (click here if you are using older version). After comparison is complete, two worksheets are compared side by si...

Excel VBA compare worksheets

Posted on December 24, 2015December 25, 2015 by Wyman W

This Excel tutorial explains how to use Excel VBA to compare worksheets. You may also want to read: Excel compare Worksheets using Compare File Excel compare worksheets Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus. After comparison is complete, two worksheets are compared side by side and you get the below result indicating all the difference...

Excel VBA export Excel to Word

Posted on December 21, 2015December 7, 2016 by Wyman W

This Excel VBA tutorial explains how to export Excel to Word. You may also want to read: Export Excel to PDF Excel VBA export Excel to Word In the previous post, I demonstrated how to export Excel to PDF, which is very easy because there is already a built in function to do that (using Save As and choose PDF). However, there is no built in function to export Excel to Word. Fortunately Excel cell is actually a table in Word, we can simply copy the cells and paste to Word. This tutorial ex...

Excel protect workbook with password

Posted on December 20, 2015December 21, 2015 by Wyman W

This Excel tutorial explains how to protect workbook with password with VBA and without VBA. Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide worksheet with password. Hide the worksheet and add a password to unhide...

Excel VBA Workbook.SaveAs Method

Posted on December 19, 2015January 29, 2017 by Wyman W

This Excel VBA tutorial explains how to use Workbook.SaveAs Method. You may also want to read: Excel VBA convert CSV to Excel Excel VBA Workbook.SaveAs Method VBA Workbook.SaveAs Method is same as the action Save As The options under Tools are also available in VBA Workbook.SaveAs Method. For example, we can add password to workbook. To understand what Workbook.SaveAs Method is capable of, let's see what arguments it has. Syntax - Excel VBA Workb...

Excel add password to workbook

Posted on December 17, 2015March 8, 2016 by Wyman W

This Excel tutorial explains how to add password to workbook with VBA and without VBA. You may also want to read Add password to all Excel workbook in folder Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide w...

Check Excel #N/A using ISNA Function

Posted on December 16, 2015 by Wyman W

This Excel tutorial explains how to check Excel #N/A cells using worksheet formula ISNA and VBA Function. You may also want to read: Excel IFERROR Function Cause of Excel #N/A #N/A is usually caused by lookup related functions where a value cannot be found in lookup table. Lookup Functions include Vlookup, Match, HLookup, Lookup. Another common cause is that when you use an Add-In formula, and then send the file to someone who doesn't have that Add-In. The formula was fine at the time...