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...]
Change Text Case to lower, UPPER, or Title Case
Do you want to have a list of information in all CAPITAL LETTERS, all lower case, or All In A Title Format? This would be an extremely tedious task if, say you have 100+ lines that need to be updated. With these macros, you can select the cells you wish to update and change their case in a flash! Note: These macros won't change the output of a cell with a formula in … [Read more...]
Set Excel Zoom Level
OK, so your co-worker or boss has one of those enormous monitors, and you're stuck working on this little tiny laptop screen. Every time they open a file, they change the zoom setting to 50%, because heaven forbid they look at things any other way. Then, they go ahead and save the file at a 50% zoom. The next time you open the file, you're squinting to try to see the little … [Read more...]