How To - Excel

Excel - Macro-Highlight if difference > or < 2

I need help writing an Accounting excel macro I am working on. It appears... Read more

Excel

February 1, 2010 at 09:20 AM

Excel - A macro to increase a cell reference

I want a macro that on open will increase the cell reference in a cell by 11... Read more

Excel

July 3, 2012 at 06:17 AM

Excel - How to create a ComboBox

If you want to add a ComboBox to one of your worksheets, in order to hace... Read more

Excel

September 9, 2010 at 08:48 AM

Excel - The MROUND function

This function will return a number rounded to a specific... Read more

Excel

November 15, 2011 at 11:22 AM

Excel - A macro to get the equivalent numerical codes for colors

This macro allows you to get a color code, you can modify it to your... Read more

Excel

November 22, 2012 at 04:32 AM

Excel - Copy rows until a given line

I'm trying to split one spreadsheet into several ones. The splitting has to... Read more

Excel

December 22, 2011 at 07:05 AM

Excel - The POWER function

This function will raise a number to a power and return a... Read more

Excel

November 15, 2011 at 11:27 AM

Excel - If then statement for commission

I am trying to set up an if then formula that would basically say... Read more

Excel

January 3, 2010 at 05:24 PM

How To Insert Multiple Blank Rows in Excel

Creating a macro in Microsoft Excel offers users the ability to automate... Read more

Excel

September 30, 2015 at 03:19 PM

Adding a VBA Command Button

Adding a VBA Command Button with its respective code is not a complicated... Read more

Excel

June 10, 2020 at 04:02 AM

Excel - Macro to detect and hide blank rows

I want a macro to unhide about 20 blank rows copy values into the top row... Read more

Excel

December 7, 2011 at 09:48 AM

Excel - Tasks to be performed automatically on particular dates

I have a huge spreadsheet and I am constantly updating it. Is it possible to... Read more

Excel

June 20, 2012 at 01:40 PM

Excel/VBA - Running a Macro/Userform

I am a beginner in VBA programming and I have a worry in the execution of a... Read more

Excel

August 13, 2012 at 10:11 AM

Excel - A macro to copy/paste a selected range

I have a summary of data by month in one sheet and the raw data in another... Read more

Excel

November 18, 2012 at 03:32 AM

Credit Summation Formula Excel

MS Office Excel is a spreadsheet application. The spreadsheet allows an... Read more

Excel

July 27, 2020 at 01:59 AM

Excel - Comparing cells across multiple columns

Excel is a handy tool for data manipulations and comparison of multiple data... Read more

Excel

November 8, 2012 at 03:33 PM

getting the week number automatically

I need to get the week number automatically... Let say I enter the date in... Read more

Excel

August 26, 2010 at 02:25 AM

Excel - Enter text in bold for a particular cell

I'm looking for a VBA code: I wish for each cell in column B, or for a... Read more

Excel

February 7, 2012 at 06:35 AM

Creating Shortcut key to merge cells

If there a shortcut to be pressed on the keyboard to merge cells in excel? I... Read more

Excel

November 6, 2009 at 01:17 AM

Excel - Copying row from another sheet

I am working with 2 Excel, One field is common in both the excel... Read more

Excel

March 25, 2010 at 07:56 AM

Subscribe To Our Newsletter!