Is there a command in Excel to check if a set of rows is directly equal to another set. For instance I want to check if the values inside rows 1 to 10 is equal
I have an xlsx that has two sheets: on has some data in G1:O25 (let's call this "data") and one that has some images inserted into cells in G1:O25 (let's call t
I'm trying to do an excel where to import some data with validations and I've never used npoi before (and my knowledge of excel is as user) so I'm kinda lost a
I need dynamically set via VBA NumberFormat to imported txt file values, as just below : Imported values number type is "General" so I want to
I'm trying to find the column number using a =match formula. In particular I am looking for a result of 42. As you can see, the formula looking in row 16 finds
A small introduction: I need a script that takes an Excel and based on a json that I give to him it sends a Mail to a list of person with attached the same Exce
I have a sheet called "Scores" where I have Column D and J with values from 1-9 in both columns. In this same sheet I have a Column A with the corresponding nam
I'm using Outlook 365 - Microsoft Exchange(owa). I have written a script that looks for emails in my Outlook Inbox with any subject line containing "PHI Attriti
I have a macro in Excel to delete mails older than 30 days from folders and subfolders in a shared mailbox. I have a sub for looping through each subfolder and
I have one column (E) trying to change the Arabic characters to English one. these data i import it as it is from JSON file. How to change these Arabic characte
I'm working with 60 different datasets, each of them with a ton of data in them. I'm trying to build a loop to go through each of the datasets (they are text fi
Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res
Can anyone explain what is happening here? I have some values in column A that I want to use with the match function. But there are some numeric values that don
I am currently using a VBA code from Kutools that lets me combine all my worksheets into one combined "Master" sheet. However, every relevant worksheet is prece
I am trying to create a login form where the username and password input match the data on a sheet. I tried to code for if either the username or password is wr
I have a more than 1000 pdf files and I want to extract/pull data from pdf. If I use the pdf to excel conversion then it will take long time so I am trying pull
I'm trying to write a VBA to check if particular files exists in folders. For example in my code, there are 3 files that belong to folder 1, and 1 file belong t
I create a function to sum all the cells within a range as following Function SumTest(rg As Range) As Double Debug.Print "SumTest..." Dim s As Double s
I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the same row using an equation I have. if there is
I am adding a new excel file to a SharePoint Library. The Library requires check-in or check-out. When closing the excel workbook, a dialog pops up in the backg