How To - Excel

Apply an IF Function Using Dates and Text

The IF function is one of the most flexible functions in Microsoft Excel and... Read more

Excel

July 8, 2020 at 05:58 AM

VBA - Count the number of colored cells

I'm looking for VBA code under which we can determine the index of the last... Read more

Excel

July 18, 2010 at 09:17 AM

Excel - A Macro to copy and paste data in next blank cell

In this article we will show you an example of a Macro that can copy data in... Read more

Excel

October 19, 2020 at 04:01 AM

Excel - Comparing two cells from different spreadsheets

Consider the following situation: Spreadsheet A Sheet1 Name Expenses... Read more

Excel

November 6, 2016 at 02:06 PM

Excel - Unique text formula

I have 2 columns of names in columns a & b and a list of dates in column c.... Read more

Excel

October 26, 2012 at 04:12 AM

Cell input to call macro in adjacent cell

I have a scenario that i'd like automated. The scenario is as follows If... Read more

Excel

November 18, 2009 at 09:16 AM

VB6 - Manage INI files + Miscellaneous functions

This demo includes a BAS module to write and read in an INI file and a form... Read more

Excel

March 1, 2011 at 11:22 AM

Excel - A macro copy to cell based on a specific criteria

I'm stuck. I hope someone can help me out today. I have an excel spreadsheet... Read more

Excel

October 13, 2011 at 11:30 AM

Automation of running excel macros

I have a macro in excel which needs to be run once a day and I don't even... Read more

Excel

March 5, 2010 at 04:57 AM

Help with Interface/Msgbox in VBA

Hi, I'm in a VBA course and I'm having a lot of trouble with one of the... Read more

Excel

March 20, 2010 at 08:54 AM

Excel - Match a string to a column & increment by 1

I have two sheets with data as follows: Sheet : String, result... Read more

Excel

May 11, 2010 at 07:14 AM

Excel - Date formula issue

I need an excel formula that tells me if a cell = a date to return yes or... Read more

Excel

March 20, 2012 at 12:27 PM

Adding a Sheet to a Workbook Using VBA

In this article we will show you how to add a sheet to an Excel workbook... Read more

Excel

July 20, 2020 at 02:24 AM

Excel - Countif formula issue

In my Excel sheet, Column "B" has the "Pending or... Read more

Excel

July 30, 2012 at 04:57 AM

Type Several Lines in a Single Cell in Excel

It may be needed that you want to type multiple lines of text a particular... Read more

Excel

July 21, 2020 at 12:28 PM

Excel - The COLUMN function

Returns the column number for a given cell or cell... Read more

Excel

November 14, 2011 at 07:33 AM

Excel - Extract string of characters

I want to extract a string except the last x characters from a cell, and... Read more

Excel

February 15, 2013 at 05:03 PM

Excel - How to hide a sheet or workbook

In this article you will learn how to hide sheets or workbook in... Read more

Excel

August 1, 2014 at 04:20 AM

Excel Functions IF, AND, OR, and NOT

This article will explain how to use the conditional functions IF, AND, OR... Read more

Excel

April 20, 2020 at 04:22 AM

Excel - Clear the contents of specific cells

I have 6 cells with dropdowns list and they are selected each time. I wish... Read more

Excel

December 7, 2011 at 09:47 AM

Subscribe To Our Newsletter!