Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open your Excel workbook. Method 1. Name Your Excel Macro Auto_Open The simplest way to get a macro to run automatically is to actually just name the macro Auto_Open. This first method does have limitations which will be covered in its explanation below. The macro needs to be stored in the workbook you … [Read more...]
Macro Mondays -Open An Excel Workbook To A Specific Worksheet Tab
Hello Excellers time for some Macro fun today. Let's look at setting Excel to ALWAYS open at a specific work sheet or tab no matter what worksheet was active when the workbook was last closed and saved. This is especially handy if you have a workbook with a large number of worksheets. If you want to see all of the blog posts in the Macro Mondays Series you can do so by clicking on the link below. How To Excel At Excel - Macro Mondays Blog Posts. If you want to download all of the examples … [Read more...]
Excel Pivot Table Tip – Show Only The Top 10 Items In A Pivot Table
This tip is really useful if you have a Pivot Table with a large number of Row Items such a product ID's and you only want to show your top selling products. You may have hundreds or even thousands of products but you only want to look at the data of your Top 10 selling products. Instead of manually choosing the top 10 items... with a few clicks Excel does all of the hard work. First we start with a standard Pivot Table- if you need more information on Pivot Table Basics you cam check out … [Read more...]
Formula Friday- My formula is not working- top reasons your formula is showing in Excel not the results.
Happy Friday Exellers . You may have already come across this problem, and if you have not, you probably will at some point when using Excel. The mysterious case of your formula is showing in the cell not the result of the formula looking like this. Whilst it is really frustrating there are a number of reasons this can happen, and usually I just work my my way through them to resolve the problem. You have show Formulas selected. You have have in error or accidentally hit CTRL+' … [Read more...]
Recommended Excel Resources
