Daily Dose of Excel

Daily posts of Excel tips…and other stuff

• Recent Comments:

  • Merge data from different workbooks with the RDBMerge add-in (19)
    • Nina December 03, 2008
  • Formatting ratios (11)
    • Keith December 02, 2008
  • The Future of Excel Charting (37)
    • Brett December 01, 2008
  • Ribbon, You’re Nothing to Me Now (23)
    • Ron de Bruin November 30, 2008
  • Number Stored as Text (76)
    • Gary Bouwman November 28, 2008
  • Creating Classes from Access Tables (7)
    • Bob Phillips November 28, 2008
  • Printing Fit to Page Width (14)
    • Jill Fisher November 28, 2008
  • AutoFiltering on Months (6)
    • Dave November 28, 2008
  • Spellchecking One Cell (15)
    • Peder Schmedling November 28, 2008
  • Hello! and a report of an initial UI-specific experience porting an Excel add-in to 2007 (11)
    • Mortimer November 27, 2008
  • ListView (15)
    • Rifter1 November 26, 2008
  • SUMIF Between Two Dates (190)
    • Randy Harmelink November 26, 2008
  • Linking Userforms and Worksheets: Part VI (7)
    • Dick Kusleika November 26, 2008
  • Formulas for Unique Data (11)
    • JOHN November 26, 2008
  • Summing in 3D (9)
    • Ashok Kumar November 26, 2008
  • Creating Hyperlinks (26)
    • Raghav November 25, 2008
  • Conditional Data Validation (36)
    • D Heutel November 25, 2008
  • XML and Excel (9)
    • Jan Karel Pieterse November 25, 2008

• Categories

  • Automation
  • Books
  • Bugs
  • Charting
  • CodeCritic
  • Downloads
  • Excel Alternatives
  • Excel Experts E-Letter
  • Excel12
  • External Data
  • Fluent UI
  • Formatting
  • Formulas
    • Array formulas
  • Games
  • General
  • Goal Seek
  • Links
  • Miscellany
  • MVP
  • Polls
  • Printing
  • Products
  • Sports
  • Tutorials
  • User Interface
    • Add-ins
    • Controls
    • Copy and Paste
    • Data Validation
    • Filtering
    • Finding Data
    • Hyperlinks
    • Names
    • Navigation
    • Pivot Tables
    • Toolbars
    • Tools Options
    • UI File Operations
  • VBA
    • ActiveX Controls
    • Application Object
    • Arrays
    • Classes
    • Collections
    • COM Addins
    • CommandBars
    • Enumerations
    • Events
    • File Operations
    • Modules
    • Range Object
    • Registry
    • User Defined Functions
    • Userforms and Controls
    • Variables and Data Types
    • VBA Functions and Keywords
    • Workbook Object
  • VBA Advanced
  • VBA Basics
  • VBA Code Library
  • Visual Basic Editor
  • Weblogs
  • Windows API
  • Wishlist
  • Worksheet Functions
    • Counting and Summing Functions
    • Date Functions
    • Financial Functions
    • List and Table Functions
    • Math and Stats Functions
    • String Functions
  • XLM

• Archives

  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007
  • April 2007
  • March 2007
  • February 2007
  • January 2007
  • December 2006
  • November 2006
  • October 2006
  • September 2006
  • August 2006
  • July 2006
  • June 2006
  • May 2006
  • April 2006
  • March 2006
  • February 2006
  • January 2006
  • December 2005
  • November 2005
  • October 2005
  • September 2005
  • August 2005
  • July 2005
  • June 2005
  • May 2005
  • April 2005
  • March 2005
  • February 2005
  • January 2005
  • December 2004
  • November 2004
  • October 2004
  • September 2004
  • August 2004
  • July 2004
  • June 2004
  • May 2004
  • April 2004
  • March 2004
  • January 2004