-
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
ExcelFebruary 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
ExcelOctober 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
ExcelJuly 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
ExcelJuly 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
ExcelFebruary 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
ExcelFebruary 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
ExcelMarch 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
ExcelJuly 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
ExcelDecember 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
ExcelJune 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
ExcelOctober 31, 2012 at 06:12 PM -
Excel - Multi-Purpose monthly schedule
This application allows you to manage a Multi-Purpose schedule using... Read more
ExcelOctober 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
ExcelOctober 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
ExcelNovember 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
ExcelJuly 3, 2013 at 10:58 AM -
Excel - The COS function
This function returns the cosine of a number (representing an... Read more
ExcelNovember 19, 2011 at 10:07 PM -
Excel – Copy to next blank line
<!-- TOC --> I'm new to macro - so don't laugh... I'm trying to... Read more
ExcelJanuary 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
ExcelNovember 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
ExcelOctober 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
ExcelDecember 10, 2009 at 03:52 PM