Home > IT Blogs > Beyond Excel: VBA and Database Manipulation/

Beyond Excel: VBA and Database Manipulation:

April, 2011

1
April 18, 2011  11:47 AM

“Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?”.



Posted by: Craig Hatmaker

This question was posed and answered by "Mr. Excel" and "Excel is Fun" in a recent YouTube post by the same title.  Their solutions work well.  I'm going to answer with what I believe is a better approach.  It uses Tables. Tables have...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

April 7, 2011  3:41 PM

Getting User Names from Outlook Into Excel



Posted by: Craig Hatmaker
database, development, dynamic ranges, excel, ListObjects, Microsoft Excel, ms query, odbc, Outlook, sql, Tables, tutorial, vba

The company president's mother died.   The staff wanted to express their sympathy.  Cards were purchased and now we needed to make sure everyone got a chance to sign them.  We needed names on a check...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

1