How To - Excel

Excel - A macro to create new workbook and copy data

I am looking for macro to copy rows based on partial cell content of a... Read more

Excel

February 22, 2012 at 09:12 AM

Excel - How to count rows which show specified dates?

I am trying to get help with stats. I have a spreadsheet that shows the... Read more

Excel

October 20, 2016 at 10:02 AM

Visual Basic - Deleting rows in spreadsheet

I have data in Sheet2 up to 900,000 rows and to Column Q (the values... Read more

Excel

July 25, 2011 at 05:09 AM

Excel - A macro for deleting row on condition

Macros can be used for various operations on Excel Worksheets such as... Read more

Excel

July 3, 2012 at 06:23 AM

Search function in VBA/Excel

I try to make a macro that looks for a value in a database and that copies... Read more

Excel

February 22, 2012 at 09:30 AM

How to compare two workbooks/worksheets

I need to compare two Excel sheets. How can this be achieved? You can... Read more

Excel

February 18, 2013 at 04:52 AM

Excel - Compare column A & B give results in column C

I have Data in Column A & B which runs up to 55000 columns sometimes only... Read more

Excel

March 30, 2010 at 07:50 AM

VBA - Conditional formatting- Apply color to last column

I want to do a conditional formatting but I am facing the following... Read more

Excel

July 26, 2011 at 06:52 AM

Excel - If formula sum not blank

I'm sorry if my question had already been asked before but I can't find any... Read more

Excel

December 9, 2009 at 08:42 AM

Excel - Color cells on condition

I have an Excel Sheet which contains Sales Figure an insight of the Excel... Read more

Excel

June 13, 2012 at 11:27 AM

VBA - Create a series of buttons on a Excel worksheet

This example shows how to create two buttons to fill up two particular colum... Read more

Excel

October 31, 2012 at 06:12 PM

Excel - Multi-Purpose monthly schedule

This application allows you to manage a Multi-Purpose schedule using... Read more

Excel

October 13, 2012 at 03:48 AM

Excel/VBA - Select cells between 2 keywords

I'm trying to write a macro that starts from the active cell - goes up the... Read more

Excel

October 20, 2016 at 09:57 AM

Excel- .xlsx are not being associated

I have installed Microsoft Office Pro 2010 (32 bits) on Windows 7 Pro 64... Read more

Excel

November 6, 2016 at 02:10 PM

Excel (VBA) - Open Outlook and send a file

I wonder if you can create a button (Type: OptionButton) which, when pressed... Read more

Excel

July 3, 2013 at 10:58 AM

Excel - The COS function

This function returns the cosine of a number (representing an... Read more

Excel

November 19, 2011 at 10:07 PM

Excel – Copy to next blank line

I'm new to macro - so don't laugh... I'm trying to... Read more

Excel

January 24, 2010 at 10:54 AM

Excel - Data validation formula

I have a spread sheet that tracks attendance. What I want to do is to alert... Read more

Excel

November 21, 2011 at 01:31 PM

Excel - Conditional deletion of rows

I have a spreadsheet where column A is a project name then columns B, C and... Read more

Excel

October 6, 2012 at 05:15 AM

Excel - - if then else with multiple criteria

Essentially, I would like to determine a numeric value (1-9) for the letters... Read more

Excel

December 10, 2009 at 03:52 PM

Subscribe To Our Newsletter!