Search results

Hello Madocor You can use the following VBA code to delete all empty TextBoxes on the active sheet: Sub RemoveEmptyTextBoxes() Dim shp As Shape ' Loop through all shapes in the active sheet For Each shp In ActiveSheet.Shapes ' Check if the shape is a TextBox and if its...

JB- This code should copy the data from each event sheet, sort it by Enrollment number, and paste it into the consolidated sheet. Additionally, it deletes the temporary event sheet after copying the data. Please give it a try and let me know if it resolves your issue. Option Explicit Sub...

Hello I think you can use the combination of INDEX and SMALL functions along with IF and ROW functions to create an array formula. Place the following formula in cell G2 of your 'Reference' tab: =IFERROR(INDEX('Consolidated'!C$75:C$95, SMALL(IF('Consolidated'!B$75:B$95=G$1...

Hello Jutu As per my understanding you're dealing with a change in hierarchy order options in your visual graphs. If dragging doesn't work, check if there's an option to reorder hierarchy levels in the settings or view model. If you're still having trouble, consider consulting the latest...

Mr. AL This code extracts the necessary parts from the formula, creates a new formatted text, and then applies the formatting without erasing the original formula. Adust as per your requirement Sub FormatTextWithoutErasingFormula() Dim ws As Worksheet Dim cell As Range Dim...

In that case the data by Application # and calculate the metrics for each unique application, you can use Excel's PivotTable feature. Here's a step-by-step guide: 1. Open your "Sample.xlsx" file. 2. Select the range of your data, including column headers. 3. Go to the "Insert" tab in the...

Hello Agyani Here's a basic outline of the formulas you might use:Column B (Total Days with the applicant): =SUM(I4:I14)+ABS(I3) Column C (Days Project[Application#] tracked):=NETWORKDAYS.INTL(G3,G14)Column D (Last time QA tracked since first time it was tracked): =NETWORKDAYS.INTL(G3,H14)...

Hello RIa 3 things to consider 1. Testing the `INDEX` function as a replacement for `OFFSET` is a good approach. It can provide a more efficient and stable solution for dynamic ranges. 2. Applying the `MAX` function to limit the scrollbar's maximum value based on your data range length is a...

Hello Jues. First time ever on Chandoo.org so detail question,Really appreciated. Try this, as took some time to understand your problem statement and could able to draw some suggestion give a try. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$I$8" Then...

Hello JUTU If you're facing issues with your Power BI date slicer and DAX logic. I can offer some suggestions to help resolve the problems you mentioned: 1. Custom Type Graying Issue: - Ensure that the 'Date Slicer Filter' DAX expression is correctly evaluating to 1 when the 'Custom' type is...

Riya- It seems like you're dealing with dynamic data ranges and scrolling issues in Excel 2007. I can't directly view or manipulate files, but I can guide you through potential solutions: a) Adjusting Data Display: - Ensure that the range references in your named ranges are dynamic and...

It's great to hear about MaisonData's initiative! For your questions: 1. Preferred Visualization Formats: - As Excel users, individuals often prefer a mix of bar charts, line graphs, and pie charts based on data types and presentation needs. 2. Desired Features/Tools: - Improved...

Hello Agyani please provide more details so I can assist you better.

Hello Jb Can you help with the error code to modify the code for you

Hello Yani As per my understanding! =SUMIFS(INDEX($H$2:$T$1000, , MATCH(TEXT(A2,"mmm"), $H$1:$T$1, 0)), $A$2:$A$1000, ">="&DATE(YEAR(A2), MONTH(A2), 1), $A$2:$A$1000, "<="&EOMONTH(A2,0)) Please adjust the range accordingly

Hey Jb...Try this, as per your requirements ! Option Explicit Sub GenerateConsolidatedList() Dim wsEventList As Worksheet Dim wsConsolidated As Worksheet Dim lastRow As Long Dim eventCell As Range ' Set references to worksheets Set wsEventList =...

Hey Debaser, Please do let me know if you are facing any issue

Hello Pierre. Please try this For Type 10, in cell H12: =SUMIFS($H$3:$J$8,$G$3:$G$8,H$11,$I$3:$I$8,"<>")+SUMIFS($H$14:$J$19,$G$14:$G$19,H$11,$I$14:$I$19,"<>") For Type 20, in cell H13: =SUMIFS($H$3:$J$8,$G$3:$G$8,H$12,$I$3:$I$8,"<>")+SUMIFS($H$14:$J$19,$G$14:$G$19,H$12,$I$14:$I$19,"<>") For...

Hello Spp Can you please help with more details like problem statement and columns And output you are looking for?

Hello Jb I think to look up the class for the corresponding event in C3, you can use the VLOOKUP function. Assuming your "event_list" sheet has class names in column A and event names in column B, you can use the following formula in D4 of the "consolidate" sheet: =IFERROR(VLOOKUP(C3...

I appreciate your feedback. Could you please specify which second question you are referring to and provide details to support your Query?

Check this Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) ' Triggered when there is a change in the "Event List" sheet Dim eventListSheet As Worksheet Dim consolidatedSheet As Worksheet Dim eventCell As Range Dim eventName As String ' Set...

Hello Jamesh I have little knowledge, but wanted to give a try suggesting you. You can Consider using a stacked bar chart to show market sizes in 2022 and 2023. Each bar represents total market size, and segments within the bars represent subsections. Highlight the growth segment with a...

Try this should work as per your requirement. Sub ExportSheetsToPDF() Dim folderPath As String Dim sheetName As String Dim wsMenu As Worksheet Dim i As Integer ' Set the menu sheet Set wsMenu = ThisWorkbook.Sheets("menu") ' Choose folder for saving PDFs...

Hey Smabit Try this =COUNTIFS($B$2:$B$13, B2, $A$2:$A$13, A2) Drag this formula down for the entire column C. This formula counts the unique customers for each shop number.