Hello, Excellers. Welcome back to more Excel VBA in today's #MacroMonday blog post in my 2020 series. I will show you how to write a really simple Excel macro that will copy the active worksheet to...
Recent Posts
Excel Tip. Copy A Worksheet And Create A New Excel Workbook.
Hello, Excellers. Time for another Excel tip. I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one...
Excel Tip. Highest And Lowest Selling Price of Product Using MINIFs and MAXIFS.
Today's Excel tip is a question I was asked recently by a subscriber. It was to achieve an easy way to find the lowest and highest selling prices for a range of products. So, Welcome back to...
Today I want to share with you a very useful Excel VBA macro. This is a small bit of code that come in useful to easily highlight all cells in your Excel worksheet that have data validation. I...
Hello, Excellers. I think this next #Excel tip will come as a relief, especially if you have inherited a workbook. Yes, quick statistics about your Excel workbook are now available.!. You may need...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 Excel series. This method will show you how to trace which cells contain the values to specific formula...