Search results

Hello Gina, You're welcome! No worries, setting up the structure can be a bit tricky at first. Here’s a simple example to help you visualize how your data and leaderboard can be set up: 1. Data Source Sheet Structure (e.g., “Data” sheet): Name Month Score Alex Jan 50 Maria Jan 60 Alex...

Hello Gina, You can set up a dynamic leaderboard that pulls data from another spreadsheet and updates based on the selected month. Here’s a step-by-step approach: 1. Use the INDIRECT or IMPORTRANGE Function (depending on your Excel version): If your data is in another workbook, you can use...

Hello Isaggs, It sounds like you’ve created tabs (worksheets) using VBA/macros, but some of them stop working or become unresponsive. This is a common issue and can be caused by a few things: Possible Reasons & Solutions: Event Macros Disabled: If your tabs rely on worksheet event macros (like...

Thanks for the detailed update! The Error 2042 from the Application.Match usually means the value wasn't found. A few quick checks: Ensure v is a string: v = CStr(v) Use Debug.Print "|" & v & "|" and compare with each header to spot hidden spaces or characters. Range(sTempRange).Offset(-2, 3)...

You are most welcome. Glad to hear that the solution worked. Keep exploring Excel with ExcelDemy and help each other to make the community stronger.

Hello, I see what you’re trying to do, and you’re close, but there’s a misunderstanding in how Enums work in VBA and how to reference them dynamically. What’s happening: v = Application.VLookup(...) returns the name of the BudgetItem as a string (like "Entertainment"), not the Enum value...

Hello Malt, This error typically appears when you're using features like PivotTables, Charts, or Data Validation that rely on a specific reference range, and that reference is broken, missing, or incorrectly defined. Here are a few things you can check: Named Ranges: Make sure any named range...

Hello Julie, Try this updated code and let me know: Sub FormatWeeklyBadgeReport() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim nameToFind As String Dim cell As Range Dim dict As Object Set dict = CreateObject("Scripting.Dictionary") Set ws =...

Hello Julie, The problem most likely arises from ws not being properly set, especially when running the macro from the Personal Macro Workbook, which doesn’t automatically refer to the intended worksheet in the active workbook. ws.Range("C4:M" & lastRow).Sort Key1:=ws.Range("C4")...

Hello Ehunt256, You're doing an amazing job pushing through each challenge, and your persistence is really paying off! Let’s walk through your three key requests and update your macro accordingly so you can finish strong Private Sub CommandButton1_Click() Dim sn As String Dim wsLog As...

Hello Tsd5562, You can use the following VBA code to automatically insert a new column labeled "Gross Profit" to the right of "Revenue (USD)" and calculate the values as Revenue – COGS for each row: Sub AddGrossProfitColumn() Dim ws As Worksheet Dim lastRow As Long Dim i As Long...

Hello Badriah, Great job on creating your first User Defined Function (UDF)! Let me address your questions one by one: 1. Why use Function instead of Sub for custom formulas? In VBA, Function procedures return a value, which is necessary for creating custom Excel formulas. On the other hand...

Hello JulieVDM, Based on your detailed requirements, here's a comprehensive VBA macro that automates the formatting process you've described. Please ensure that your data starts from row 3, with headers in row 3 and data from row 4 onwards. Also, back up your workbook before running the macro...

Hello Adg322, You’re definitely not alone in feeling that way, it is frustrating doing it manually! The best approach here is to use a web scraping tool like Power Query in Excel or Python with BeautifulSoup. For a no-code option, Power Query can pull structured data directly into Excel if the...

Hello Bart Van Hout, The previous formula using LOOKUP returns the highest matching score below or equal to the time, which causes incorrect scoring for cases like 3'11" or 4'16", as it doesn't shift down to the next row when there's no exact match. Revised Formula for G2 (score): =IF(C2="J"...

Hello Gary Thornton, Thank you for the follow-up and for sharing your formulas! You can nest your logic inside an additional IF that checks the final outcome to suppress zero or negative results. Here's how you can modify your formulas: Your Formula...

Hello User_2025, Welcome to the world of Excel VBA! It’s great that you're focusing on the fundamentals while avoiding common pitfalls, a solid approach. Here’s a quick breakdown of your questions: 1. Difference between a Sub and a Function in VBA: A Sub (Subroutine) performs an action but...

Hello SGustaveson, Hi there! You're doing a great job organizing the score sheets, and automating this in Excel is doable and can save tons of time! To make your process smoother and formulas more reliable, I highly recommend updating the sign-up sheet format just a bit. Specifically: Split...

Hello Gary Thornton To suppress zero and negative results in your spreadsheet, you can use an IF formula like this: =IF(A1<=0, "", A1) This formula checks if the value is zero or negative; if it is, the cell is left blank (""); otherwise, it displays the original value. You can apply this...

Hello Ehunt256, To insert these marks, you have two easy options: