Its time for some more fun with another Excel #MacroMonday blog post in my 20201 series of #Excel and VBA Tips. Today let's look at a useful tool to generate random numbers in a selected range of cells. I use this regularly to populate a range of cells in an Excel workbook with random values to test my spreadsheet solutions. To have this in your VBA Macro toolbox sure is a handy one!. Storing The Excel Macro. Before we begin to write any code you need to decide where to store the … [Read more...]
Calculate The Percentage Discount In Excel.

Hello Excellers, welcome back to another #FormulaFriday #Excel blog post in my Excel 2021 series. Do you need to know how what discount has been applied to a product?. If you need to calculate the percentage discount well it is really easy. Today's Excel excitement is inspired by not only January sales discounts, but a question from a subscriber. Original Price And Discount Price. So, if you know the Original product price and also the Discounted product price, we can get Excel do … [Read more...]
Excel VBA to Insert Multiple Rows Based On Cell Value

Hello, Excellers and welcome back to another #MacroMonday #Excel blog post in my 2021 Excel series. Today I want to show you how to write s macro to insert and copy a number of new Excel rows into your spreadsheet. The number of rows, however, will be variable and will depend on a cell value. This is a nice flexible alternative solution to inserting a standard number of rows after each data containing data in Excel. My YouTube video solution to that is linked … [Read more...]
Extract Initials From Data No Formulas – Flash Fill.

Hello Excellers welcome back to another #Excel #FormulaFriday in my 2021 series. Today I want to show you how to extract the first letter of a first and second name without using Excel formulas. We can use the Excel Flash Fill feature to do this for us. So, yes Excel will do this for you without a formula or function in sight. Here is a sample of my data set. I have highlighted the column I want to populate with the Sales Person's initials. To get Excel to populate … [Read more...]
How To Enable And Disable Macros In Excel.

Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable and also disable Macros in Excel. Now, Excel Macros can be used for good or not so good. So, as a consequence, you have a choice to enable them or disable them in Excel. We can also store them in trusted locations. With the release of Excel 2010, the security model changed significantly to previous versions. It introduced the concept of 'Trusted … [Read more...]
- 1
- 2
- 3
- …
- 43
- Next Page »