I am not a fan of the merged cell format. It causes more problems that it solves. One issue you will face is trying to select a single column range within a range that has a merged cell. Here is how you handle it.
This post is a video post as it easier to show the problem and the solution in a video.
You don’t get harmony when everyone sings the same note.
Doug Floyd (the Spokesman Review – Washington paper)
I am not a fan of Merged Cells but there may be a case to use them when creating a larger Sparkline chart.
In this short video I demonstrate how to create range names quickly based on labels. Range names are a powerful formula feature. I also demonstrate their use.
There are no old roads to new directions.
attributed to Boston Consulting Group
Using colours on your sheets can help you navigate and organise your file. If you want to sort your sheets by colour you can use a macro to speed up the process.
Begin challenging your own assumptions. Your assumptions are your windows on the world. Scrub them off once in a while, or the light won’t come in.
Alan Alda – commencement speech – 1980
When working with files in VBA code, you may need to know if a file is already open. A function can return TRUE if a file is currently open and FALSE if it isn’t.
A good scare is worth more than good advice.
If you need to find the movement from the previous month a PivotTable can be your friend and do most of the work for you.