Beyond Excel: VBA and Database Manipulation:

April, 2011

April 18, 2011  11:47 AM

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

Craig Hatmaker Craig Hatmaker Profile: 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...

April 7, 2011  3:41 PM

Getting User Names from Outlook Into Excel

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: