You can use Excel as a database, as long as your requirements are limited. Create multiple sheets in your workbook, store various type data in the sheets and work with the data as and when required ...
I am sharing three simple methods here, which shows how to pull or read data, as it is, from another Excel workbook, in your computer or from a remote computer. While pulling or extracting the data, ...
In Excel, you can use the “EDate()” method to automatically add one month from the previous date or increment the previous date by one month. ...
You must be familiar with VLOOKUP function and the error #N/A, which the function often throws when it fails to find a lookup value. It can be annoying at times, since #N/A does not explain the error ...
There’s a simple division formula that you can use to calculate the sales percentage in Excel. Let us assume you have a list of items and number of items sold in a given period. Now, you want to ...
Here’s a scenario. You have a list of product and the details of each product are entered in different (3 or more) rows in a sequence. Now, how do merge all the data in different row into one single ...
You can use the LEN() function in Excel to count the total number of characters in a cell in your worksheet. The LEN (or the length) function takes a parameter (or argument), which can be a string or ...
A VLOOPUP function (also known as the Vertical function) in Excel, is often used to look up or find a value from a range of data in a worksheet. I’ll show you how you can use the VLOOKUP with the IF ...
You can use the FolderExists() method in VBA Excel to check if a particular folder exists in a computer or not. FolderExists returns a Boolean true or false and it’s from the FileSystemObject class in ...
You can use the FileSystemObject in VBA to read and write data to an external text file from Excel. The FileSystemObject provides all necessary methods and properties that would help VBA developers to ...