Last seen: Dec 22, 2025
Hi Paul, Add a new column in Power Query with a simple formula instead of using the Divide or Percent Of options. This way you will be able to deci...
Hi Paul, Attached is a visual basic module with a code that will measure the calculation time for different options: Range recalculation time (s...
You're welcome, glad to hear you managed to make it work as you wish 🙂
Sure. At the beginning of the code, Unprotect the sheet: Sheets("Sheet1").Unprotect Password:="pass" Then protect the sheet back when the code is don...
You will need to identify the things that will separate Cities from street addresses. Unfortunately, there is no easy way for that: lots of inconsiste...
Of course, you can try Jon's course. Also, Mynda recommended few weeks ago Allen's course: the Excel Macros for Beginners course Maybe he has more ...
Well, Power Query can be very useful, it can be compared with vba in terms of getting the same results in different ways. The course is available on o...
Hi Nikki, The formula is pretty simple, try to add a new column with this formula: =if [DayOfWeek]<=3 then [LeadDay] else if [DayOfWeek]>3...
Try the attached file. I defined a name for cell K7 in Pivot Table sheet (FirstCell) , this name is used in code. This will help identify in code t...
Hi Maya, Try saving the file with macros as .xlam (excel add-in), it's an alternative to personal.xlsb. It will be saved in the default add-ins fol...
The code should be in Sheet Pivot Table vba module, not in a regular module, there are sheet level events that can be triggered, and Workbook level ev...
A slicer does not have events, pivot tables can have an event associated with an action. You can loop through slicer elements to see which one is s...
You will obviously handle that in code. When a quarter is selected, use .ShowAllData before applying the top 10 filter on that column, there is no nee...
I think you can simply apply a Top 10 filter in cell O7 filter (Total), or in the other columns: L7 or M7, N7. Record a macro when applying the fil...
Power Query will import from most database formats, text files, excel and csv files. PDF format is not supported. You have to convert the PDF to excel...