compare

Hello everyone, I'm having difficulty with how to make a VBA, which compares all the values of a worksheet in another. I tried to do it this way, but it didn't work: Sub CompareSheets() Dim RowSheet1 As Long Dim RowSheet2 As Long RowSheet2 = 1 While Sheet2.Range("A" & RowSheet2).Value <>...

Hello -- thanks for reading this post. I am very stuck on this problem i have attached an image to explain better - i need to check Column B Title and Find all Exact Matching values from other Columns C D E F (attributes) and give an output In Column H I J K - in order to find out which sku has...

Hello everyone! I am working on simplifying our employee benefit reconcile process at work. With over 500 employees and 16 different enrollment options, the current reconcile process is messy and prone to errors. I've created a flow in Power Automate Desktop (PAD) that allows the user to...

Hi, I've got two workbooks ExtOrgsList.xlsx contains an ID of a Customer. The ID is in Column A and the Customer name is in Column B. Destination.csv has column AN which contains the Customer names. The code below works but if there's any deviation in the name it returns the partial match...

I am working on a project to reconcile payroll data. I apologize if I ramble, I've tried to lay this out the best that I could, but as usual, my mind is scattered! Any input or suggestions is greatly appreciated! I have an outline of what I am wanting to do: User Selection...

Hi, This is my second code in VBA, which will hopefully work; so consider me a beginner. I have two workbooks that I want to compare and highlight differences. I've prepared a VBA code but if any rows are added or deleted it marks them too, which goes against what I want to do. Aim: Every time...

Hi there, anybody can help me with the date comparison? I just want to compare two dates then i wanna know if date in colum B exceeds date in colum A for a month and 3 months. if true just put a text on colum C. ABC115/12/202215/01/2023EXCEEDS FOR A MONTH215/12/202215/03/2023EXCEEDS FOR 3...

I have a excel file with two sheets. Secon tab stored all previosu data and in the first tab I am adding new data every day. I need to comapre dates in column from 1st sheet and 2nd sheet and then copy from 1st tab only those lines where date is greater then in second tab (of course copy and...

I know this has been asked a thousand times, but my case is a little different. I have a workbook with a master sheet and then a sheet where people make updates to the data provided from the master sheet. Sometimes they add rows and some times they remove rows, change data in row cells etc. the...

Hello! I am trying to create a "user-friendly" method of comparing two workbooks and displaying the results in a new sheet. Every month I have to reconcile our employee deductions against our vendor invoice. Currently, I am using Excel with Power Query and merging the two using the employee...

hello , I have this 2 list ,and I want the same word to be in the same row ( Ex : row 1 contains : "Service 351" in A1 and "Service 82" in B1 ) , please help and ty ♥

I'm trying to run a compare though multiple sheets but i keep getting an error "Runtime error 9 subscript out of range" The code I'm trying to run is Sub Comp_TEST() Dim ar As Variant Dim var() Dim i As Long Dim n As Long Dim Last_Row As Long Dim WS As Worksheet For Each WS In...

After commenting on this thread, I was advised to post a new question. I am writing a macro to insert rows in a sheet based on whether the first part of the value in colA corresponds to a certain value in an array. Initially, I had the array fill into G3:G15 as text, then the sub compared the...

I'm looking for formulae that will compare Sheet1 and Sheet2, searching Sheet2 for cells that don't match columns C-E for the associated ID and Date (columns A & B) in Sheet1. Further, I'd like to highlight in Sheet1 whatever cells in columns C-E that don't have matches in that can be found in...

Hi all, See attachment for example My students makes a exam. I want compare two columns and return a result in an another column. Example: B5 result: M5 result compare with O1:O223, if true compare it with P1:P223 and that's the result =SUM(C5:L5) result 19 . Searching 19 in column O and...

I have two sheets with information like in the picture. (sheet 1 and 2) Sheet 1 is old information and sheet 2 is new information. Column A is the ID of the row. What i would like, is a comparision between the two sheets, where it would check for added and removed ID's (Column A), or if a row...

Good day everyone! I hope everyone is doing well. So here's what I'm trying to do...I need a VBS that will loop through a workbook of multiple worksheets and look at columns C and D for differences as long as the text does not match "Default settings" or "Configurations settings". If there are...

[having trouble uploading sample data] The credit card period runs from the 6th of month 1 and ends on the 5th of month 2. Then, the payment is due on the 2nd of Month 3. Then, the 6th of month 2 runs to the 5th of month 3. etc. I am trying to find the typical credit card amount for each day of...

The code below are for comparing two diffrent sheets in one workbook. it compares rows in column A, and it works excelent. Do anyone know how to make it compare rows through all columns (A-M), and not just A? appriciate any help. Sub Compare() Dim LR As Long Dim x As Range Dim xr As Range...

Hey you! I was trying to tweak the code provided by mumps in this thread: Find missing values between two columns with VBA With 0 success and I'm super desperate, however, I need to have this solved today in order to go to bed peacefully. The workbook is used to have an overview of Product...