Search results

Hello Andrewalwin, Yes, Excel can be used for enterprise property management, but it has clear limits. Excel works well for analysis, reporting, budgeting, and forecasting, especially when combined with structured tables, Power Query, and Power Pivot. For small to mid-sized portfolios, many...

Hello Tony Mac, Use an exact match lookup on the comma-separated tokens (no wildcards), e.g., with TEXTSPLIT + XLOOKUP: =TEXTJOIN(", ",TRUE,IFERROR(XLOOKUP(TRIM(TEXTSPLIT(A1,",")),$D$1:$D$100,$E$1:$E$100),"")) This splits A1 by commas, trims spaces, then does an exact lookup for each code (so...

Hello Pradneshwaje, You can prepare a petty cash report directly from the attached bank statement by summarizing only the small, frequent expenses and matching them with the funding entries. Identify petty cash funding Look for credits like “petty ca”, “M S NEW T / ICIC / petty ca”...

You are most welcome. Glad to hear that this solution helped you. Keep exploring Excel with ExcelDemy!

Hello Isabellar, It looks like some of the values in your range are stored as text, even though they appear as numbers. When that happens, Excel ignores those cells in the SUM calculation. Formatting the cells as “Number” does not convert the underlying value. The easiest way to fix this is to...

You are most welcome. Hopefully your problem is solved now.

Hello, It sounds like the data is being pasted below the table because the code is not detecting the table’s data range and is instead using the next empty row on the worksheet. To fix this, make sure your VBA is adding rows inside the Excel Table, not outside it. You can replace your paste...

You are most welcome. Thanks for your feedback and appreciation. Keep helping each other to make the community stronger.

Hello, You’ve done the hard part already (writing to the sheet chosen in E6: Type). To also log the same entry to Total, write the values once into an array and append that row to both sheets. The macro below is a drop-in replacement that avoids Select/Activate (more reliable) and validates the...

Hello Kata Davis, It sounds like Excel’s gridline color might have been changed globally, which sometimes happens after theme or display updates. Let’s go through a few checks to restore the default gridlines permanently: Check Gridline Visibility from the View Tab: Go to the View tab on the...

Hello AllanR, You’re very welcome! I’m glad to hear everything is working fine again. It does sound like something in the file may have become corrupted, and restoring from a backup was a smart move. If it happens again, try saving the workbook as a new file (Save As) — this can sometimes...

Hello Allan, If your Name Manager or named function stopped working, try the following steps: Check for broken references: Go to Formulas ➜ Name Manager and see if any of your defined names show #REF!. If so, edit the reference range and correct it. Ensure workbook calculation is enabled...

Hello Lisa, Great progress and thanks for sharing the exact formula and the switch from R to U. Since it’s still not calculating after widening the ranges, here are the two most common gotchas when adding Saturday: Make sure the two criteria in each SUMIFS are still matching real values in the...

Hi Lisa, I’m so glad to hear it’s working well for you and great job figuring out the year and Saturday adjustments! You’re right, adding Saturday as a new day is usually easier than adding a whole new class, since adding a new class would require updating multiple formula ranges across...

Hi Lisa! Here are the quick fixes: Extend Year list Use a dynamic list for the Year dropdown: =SEQUENCE(15,,YEAR(TODAY()),1) → auto-creates this year + next 14. Make month dates auto-fill (Year in Settings!B2, Month # in Settings!B3) =LET(y,Settings!$B$2,m,Settings!$B$3, s,DATE(y,m,1)...

Hello Ti-Paul, You’re very welcome, and great question! Yes, the formula looks for the Product No that’s in the cell you reference (in this case, $A2). So, if your Product No is in a different cell, for example, B2 or D5, you just need to change $A2 in the formula to that cell reference. For...

Hello @spring1268, Thanks for the details! Our original tutorial and sample files were created and tested on Excel 365 (Standard). Your screenshot shows Office 2019, and “custom function not recognized” in .xlsm files almost always comes down to macro loading and module placement (not a...

Hello Ti-Paul, You can total a specific Product No across multiple sheets using this formula; no VBA needed. First, list all the sheet names (except the TEST SHEET) in a range, say X2:X20, and name that range Tabs. Then use this formula in TEST SHEET!L2 (assuming the Product No is in A2)...

Hello, You can easily summarize data from your Order tab into the Order Type tab using the SUMIFS function. Use this formula in the yellow summary table (for cell C5 where Store = 1 and Category = a): =SUMIFS('Order'!C$3:C$8, 'Order'!$B$3:$B$8, C$4) Then adjust for each column (store) and row...

Hi Shivchand2002, Please explain your problem in more detail first. A screenshot of the relevant data (instead of a full file upload) will help us understand better.