SmittyPro - Witticisms, Help, Tutorials and More
Mar
27

Introduction to VBA/Excel Programming – Free Online Course

written by "Smitty"

Dr. Paul Nissenson, from CalPoly Pomona’s Mechanical Engineering Department, will be offering a free online Introduction to VBA/Excel Programming course through the university.  The 10-week course begins April 1, with enrollment though April 4, and a final exam available from June 7-11.  Non-CalPoly Pomona students with a passing grade will receive a certificate of completion […]

Read More About - Introduction to VBA/Excel Programming – Free Online Course »

Jun
5

Excel: Automatically consolidate data from multiple worksheets?

written by "Smitty"

We had a question at #ExcelHelp this week from somone who wanted to consolidate data from multiple worksheets to a master sheet. My first thougt was use Excel’s native PivotTable functionality for multiple consolidations ranges (easier than it sounds, just follow the Wizard), but this case just needed to move an inconsistent range of worksheets […]

Read More About - Excel: Automatically consolidate data from multiple worksheets? »

Apr
24

VB HTML Maker Update

written by Zack

When I first starting really getting into VBA, it was pretty invaluable to me to be able to read over my code. And over and over and over my code again. And again. As well as others code. This really helped me learn the syntax and flow. An add-in which was great, which I can’t […]

Read More About - VB HTML Maker Update »

Jan
29

Create a Table of Contents in Excel

written by Zack

There has always been a need for a good Table of Contents in Excel. While Word features this natively with its built-in Styles, unfortunately, Excel lacks this functionality due to a host of reasons, which are quite valid. However, we can create a workaround by incorporating some VBA. The following code is an updated version […]

Read More About - Create a Table of Contents in Excel »

Microsoft MVP

 

Join In

Tag Cloud

Great Links

Archives

SmittyPro.com

Welcome to SmittyPro.com, your one-stop for solutions concerning anything from beginner to extremely advanced Microsoft Excel issues and programming. Topics covered include Excel, Access, VBA, and (every now and then) some amazing observations or "Smitticisms" that might dumbfound you and send ripples of excitement or intrigue around the world.

Categories

Meta

RSS Top Stories from CNN

Vistor Counter for SmittyPro's Blog