Busy Times!

This past week around the Wyatt household has been rather busy. When we moved to Wyoming a month or so ago, there were still some fairly serious renovations that needed to occur in the house.

Well, a lot of those are in the process of getting done, and we are working away on getting the other necessary tasks done. It is fun, but very tiring.

Adding to the "busy-ness" of the week is the fact that I am in the middle of starting another Excel Macros for Beginners class. Lots of new students are signing up and starting to discover more about working with macros.

I hope that you had a good week and are looking forward to the tips in this week's issue of the newsletter.

—Allen
     

ExcelTips (ribbon) for 24 September 2016

Macros extend Excel
Importing Based on a Partial File Name

A common task for macros is to open and process a file you want imported into your workbook. If you need to identify the import file based on a partial filename, there are a few techniques you can use. This tip discusses three of them.

Read this tip »

(Thanks to Bob Beechey, Jim Williams, Hesam Kiani, Mike Roycroft, Donald Meyerson, Gerhard Schweizer, Jacques Raubenheimer, Greg Renigar, Alex Blakenburg, David Shepherd, and Piers Morgan-Harvey for contributing to this tip.)

 
Worksheet functions
Counting the Number of Blank Cells

If you need to count the number of blank cells in a range, the function to use is COUNTBLANK. This tip discusses the function, along with a "gotcha" that you should be aware of.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Printing
Printing Row Numbers

Excel displays row numbers on-screen that help you easily see what is in each row. If you want to print these row numbers, you will need to use a workaround, as they can't be printed by themselves.

Read this tip »

 
Macros extend Excel
Generating Unique, Sequential Names

Do you need to create a number of words or phrases where you only alter a few letters in each one? If the alterations follow a specific pattern, you could quickly do the creation within Excel. Here's an example.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Differences between Tables and Named Ranges

What is the difference between tables and named ranges and why would I prefer one over the other? My ranges are named, of course, and dynamic when it suits my purposes (most of the time). If they're fixed and I need to add rows or columns I simply do so in the middle.
—David Bunce (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  801-607-2035