The latest articles by Irene_Burn

  • How to run macro when data entered in a cell

    If a user wishes to run a Macro in Microsoft Excel 2007 when the D10 cell is found to be populated, worksheet change event must be used in the Excel Worksheet, not in the module. This article will show you how to run a macro when cell value changes.

  • How to use Excel color cell if formula

    Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts such as if-else conditions and looping may be useful to write user defined functions. To write a function to determine the color of a cell, the interior color object can be used.

  • How to use an IF statement to add 1 to total

    Excel is used to store, share and analyze data. It has inbuilt formulas that can be customized and combined with each other to achieve the desired results. For example, IF statement incorporates conditional statements. The user can combine IF statement with other functions to add in a conditional statement. These conditions can be based either on some text or numeric value which the formula would automatically check for.

  • How to copy a Macro into a blank cell

    In this article we will show you an example of a Macro that can copy data in the next blank cell. Using this example you should then be able to apply the solution to a specific problem that you have.

  • How to apply a function to multiple sheets on Excel

    Anyone who uses Excel will know that shortcuts and functions to make repetitive actions easier are very much welcomed. Therefore, in this article we will show you how to apply a formula to multiple sheets in Excel.