compare & delete row

Hi all, Can anyone suggest the best to go about this please? I have one workbook that contains 1000's of rows of data. Each row has an ID in column A (This ID may exist on multiple rows). I want to use another workbook that only lists relevant ID, and have the original workbook delete all rows...

I thank each and every Mr. Excel forum members who are helping hundreds of Productivity Issues daily. I am looking for a solution to remove similar duplicates by identifying the Pattern which every text ends with a Number. Based on Column A (primary key) - the macro should run on column B...

Hi all, I've joined this forum seeking Excel VBA assistance. What I am trying to do is create a rudimentary spellcheck based on a word list. There are 3 sheets in my excel file: Source - Source text with various contents. Another piece of software delivers the content and column A and H are...

Iam trying to create VBA code to compare the values in a single column andperform a calculation if the condition exist. The below table is a sample of mydata. The 1st 5 numbers of the Security is always a unique number and alwaysend with US. The difference is some lines end with an L (meaning...

I'm a novice in Excel VBA. Currently, I have imported a bunch of data into Excel. Is it possible to compare the value of current row and the next row? If there is same value occurred in column A, compare column B and the row with larger value in column B will be selected and another row will be...

Hi, i have two worksheet in one excel file, sheet1 & sheet2. Sheet1 first column is having email ids, & sheet 2 first column is email ids. i want to compare sheet1 email ids with sheet2 email ids, if match found in sheet 2 then please delete that row in sheet 2. please send me macro...