Say you have a spreadsheet that keeps track of weekly sales information, which you want displayed in a new sheet for each month. You don't want to copy an "original" worksheet each week, so a macro can help to automate this process. The macro code below will copy the worksheet named "Original", and place it after the last worksheet in your file. It will then prompt you to … [Read more...]
Format a List in Columns to a Single Column
Say you have a large contact list in Excel that is formatted, for example like: Column A - Names, Column B - Addresses, Column C - Cities, Column D - States, Column E - Zip Codes. It's great that everything is formatted in neat columns, but it would be a nightmare if you wanted to use this list to print off envelope address labels. Thankfully, there's a macro can speed up this … [Read more...]
Run Macro At a Specified Time
Using the Application.OnTime Method will allow you to schedule a macro to be run at a specified time. The specified time can be either after certain amount of time has passed, or at a certain time of day. This is especially useful if you would like a daily or weekly report to be printed, without having to be around to print it. If the report is long, it might take a while to … [Read more...]
Excel 2007
For a person who has used previous versions of Excel, Excel 2007 can be a little intimidating at first. For starters, there are none of the familiar menu options, and some of the keyboard shortcuts that have become second nature have changed. Don't let this discourage you though. With a little guidance and familiarization, you'll find that Excel 2007 is more powerful and … [Read more...]
Split a Worksheet Into Multiple Panes
You can split a worksheet area into vertical and/or horizontal panes so that you can click inside any one pane and scroll to locate information in that pane while the other panes remain in place. Drag a split box (the small box at the top of the vertical scroll bar, or at the right end of the horizontal scroll bar) in the direction you want the split to appear. To remove the … [Read more...]