How To Write A Macro To List All Files In A Folder – Macro Mondays
Hello, Excellers I am excited to share with you some cool VBA Macro fun. I find this a really useful macro which uses the Excel For Loop to list all files in a folder or directory. Similarly, we...
Formula Friday- Increase Or Decrease A Number By A Percentage In Excel
Hello, Excellers it is yet another week has gone by which means it's time for Formula Friday Excel tip. Let's take a look at percentages today and specifically increasing or decreasing a number...
Hello, Excellers welcome to another #formulafriday blog post with yet another an awesome Excel tip. No - one likes to be ignored right?....wrong?...let you decide that one, but I was asked...
An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays
Hi Excellers, welcome back to another instalment of #macromonday. Let's look at how to save a tonne of time by writing a simple Excel VBA Macro that will copy an entire worksheet from one Excel...
Identify New Customers With Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome back for aonther#formulafriday. Today I want to share how to highlight new entries into an Excel list within a specified time period. So, your boss has asked you send...
An Excel VBA Macro To Convert All Formulas To Values – Macro Mondays
Hi, Excellers welcome to another blog post in the #macromondays series. Today, let' s look at saving a tonne of time. Sounds good right?. We will write an Excel VBA macro which will convert all...