Search results

Hello, When you've formatted your data as a table in Excel, charts linked to that table should automatically update as you add or modify data. If your chart isn't updating automatically, here are several potential reasons and solutions to consider: Ensure the Chart is Properly Linked to the...

Hello, To filter your data in a specific format where each unique number in the first column has its corresponding values aligned in different columns, you can use the following formula. Formula: =FILTER(B$1:B$7, A$1:A$7=$A11) =FILTER(B$1:B$7, A$1:A$7=$B11) =FILTER(B$1:B$7, A$1:A$7=$C11) OR...

The problem of not highlighting the same cell going to the above or previous cell occurs when your cell reference is not aligned with your dataset. Adjust your formula: =ISNUMBER(MATCH(A2, Sheet2!A:A, 0)) Try with: =ISNUMBER(MATCH(A1, Sheet2!A:A, 0)) =ISNUMBER(MATCH(A3, Sheet2!A:A, 0)) Based on...

Hello Misaj, To highlight the country name of sheet 1 if it exists in sheet2, you can follow these steps: Go to Sheet 1 and select the range (select the range A2:A90 ). Click on the Home tab >> from Conditional Formatting >> select New Rule. In the New Formatting Rule window, select Use a...

Hello Imdurwood, It looks like you’ve done a lot of steps correctly! Here's how to ensure the macro works and to modify the code for your additional requests: Steps to Save and Run the Macro: To open VBA editor press ALT + F11. In the VBA editor, click Insert >> Module. Paste the full macro...

Hello Imdurwood, To count how many times each number touches highlighted cells in your dataset, you can use a VBA macro. Sub CountTouchingCells() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name Dim r As Range, cell As Range Dim...

Hello SgtIk3, To avoid REF errors when using this formula: =VLOOKUP('Input Personnel Here'!A2,'Input Personnel Here'!A:K,1,FALSE) You can switch to INDEX and MATCH will help create a dynamic solution that adjusts when rows are deleted. Here's how you can rewrite the formula: =INDEX('Input...

You're most welcome! I'm glad to hear that it worked for you! Feel free to reach out if you run into any other issues. Keep helping each other to make the ExcelDemy forum beneficial for all.

Hello Waleed, To extract the numbers after the text "مرجع العملية", you can use a combination of TEXTBEFORE, and TEXTAFTER functions. =TEXTBEFORE(TEXTAFTER(A1, "مرجع العملية"), " ") TEXTAFTER(A1, "مرجع العملية"): Extracts the text after "مرجع العملية". TEXTBEFORE(..., " "): Extracts the text...

Hello Itsnatexd, Send an email automatically when conditions are met. You can follow this article: How to Send Email Automatically When Condition Met in Excel Send Emails from Excel

You are most welcome. Keep contributing to ExcelDemy forum and help each other to build a strong Excel community.

Hello, Office Scripts contains some methods that might not exist or may be incorrectly used. try this modified code but ensure that your Excel version supports these features, and consult the Office Scripts documentation for more updates. function main(workbook: ExcelScript.Workbook) { let...

Hello Abdulwahab, To ensure that the data is added to the next available empty row in the "Marksheet" after you've manually cleared row 3, you can use the updated code to find the next empty row in column A and then enter the data accordingly. Private Sub cmdSave_Click()...

Hello MichaelP, To print a range of cells in Excel to PDF using Office Scripts (without macros), with a button to trigger the Office Script that automates the PDF export you can use the following Office Script function main(workbook: ExcelScript.Workbook) { // Select the worksheet and range...

You are most welcome. Keep sharing Excel issues and helping each other to build a community.

Hello MichaelP, If you’re looking for a manual solution to print a range of cells to PDF without using VBA or macros, you can use Excel’s built-in features. Highlight the cells you want to export (e.g., A1). Click File in the top left corner. In the left pane, choose Export. Click on Create...

Hello Caitlin S, While working through it, I noticed that you didn’t update some of the cell references, and there was an incorrect formula used in certain places. I've corrected these issues for you. Your COUNTIF formula is wrong. You are using absolute reference for all the cells. Your...

Hello Caitlin S, Please describe the issue you are facing in details and you can upload your workbook here.

You are most welcome. I hope your problem is solved now.

Hello, The row calculation is adjusted to lastRow + i + 1 to start from the next empty row. Make sure the TextBox1 contains the correct serial numbers separated by commas before hitting the "Add" button. Private Sub CommandButton1_Click() Dim serialNumbers As String Dim serialArray()...