 How to synchronize data between two sheets or ranges in ExcelIn this article, we will have a look at how to synchronize the data between two cells / ranges / columns or rows using VBA. Of course, you can use cell reference to do the same, but in cases where you need to use VBA,  How to delete columns in Excel using VBAIn this article we will see how to delete columns in Excel using VBA. Example 1: Delete an entire column in a sheet using column number: Say, the Excel data that is of the form below and you need to delete the column for May-18  How to create an Excel user form with dynamic combo boxesIn this tutorial we will see how to create a user form using VBA and dynamic combo boxes to it. The input sheet contains a number of drop downs with varying number of options in each, as seen below: Using VBA, we will create two  How to find duplicate entries across columns using excel VBAIn this article we will look at how to find duplicate entries across columns using Excel VBA. Consider you have 3 columns of data with few duplicate rows as seen below: And you need to highlight the rows that are not unique. As there is no 
How to compile and collate data from multiple workbooks and sheets into one new Excel file in VBAIn this article we will see how to copy data from multiple Excel workbooks and paste it to a new Excel Workbook. Consider you have three Excel workbooks with data in a single sheet with the same name. The range from which data is to  How to copy values from multiple worksheets to other worksheets in Excel VBAIn this article we will look at how to copy values from multiple worksheets to other worksheets within the same file based on a condition using Excel VBA. Consider you have monthly sheets (named Jan, Feb, Mar and so on) that contain stock prices as  “Next Without For” Compile Error in Excel VBA – What Does it Mean and How do You Fix it?“Next Without For” Compile Error is a very common compile-time error in Excel VBA. It implies that a Next statement must always have a preceding For statement that matches. If a Next statement is used without a corresponding For statement, this error is generated. Let us look at  How to Search a PDF for a String Using VBA for ExcelIn this article we will see how you can search for a string in a PDF file and highlight it using Excel VBA. We will look at two examples, one that works with Acrobat Reader and a second that should be used if you have  Excel VBA Paste: A Million Ways to Paste from Point A to Point BIn this article, I will show you various ways to copy and paste data using Excel VBA. The paste method is one of the most commonly used methods in Excel. There are two methods for pasting data, namely “Worksheet.Paste” and “Range.PasteSpecial”. Let us start with  VBA Select Case – An Awesome Alternative to IF-THEN StatementsThe Case statement is a very common and useful function used in VBA. Using the case statement, you can run one of several groups of statements, depending on the value of an expression. It is an easier way to write multiple IF-THEN-ELSE statements. In this article, we |
|
