Generating a Unique ID Number

If you are keeping track of people or things within Excel, you may want to devise unique ID numbers you can use for those people or things. This tip examines how to go about that and provides ideas you can use when coming up with your own ID numbers.

Read this tip »

(Thanks to Ryszard Raciborski, Charlie O'Neill, James Woolley, and Tomek Dluzniewski for contributing to this tip.)

Selecting Random Names

Got a ton of names from which you need to select a few random names? There are several ways you can extract what you need; several different ideas are explained in this tip.

Read this tip »

Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

Limiting Printing to a Workbook from a Set Location

When you share workbooks on a company server, it can be frustrating if the workbooks are downloaded to individual systems, modified, and printed. (It can make tracing the provenance of a printout challenging.) This tip looks at ways that you can make sure that only a printout of the original on-server workbook can be made.

Read this tip »

Setting Default Print Margins

Don't like the print margins that Excel uses by default? You can change the default by changing the workbook on which Excel bases the new workbooks you create.

Read this tip »

Jumping to a Specific Worksheet

Want to make fast work of moving from one worksheet to another? Here's how to do the task when you have a lot of worksheets in your workbook.

Read this tip »

Preserving the Undo List

The undo list can be a lifesaver when working in a macro. Unfortunately, the undo list is not preserved when you run a macro. Here are some ideas on how you can "undo" any changes that might be introduced by your macro.

Read this tip »

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.

Projects in Process for Each Day in a Range of Dates

My job is to track the historical start and end dates for projects within the company. So, I have two columns for each project that specify the start and end dates. I need to generate a report that shows, for a target date range, the number of projects that were being worked on for each day within the target range.
—Chelsea Bonner (provide an answer for this Help Wanted question)