Compare and Delete

D

DanielMc

New Member
Joined
May 12, 2010
Messages
1
Dataset 1
Workbook 1 (name varies)--> Worksheet 1 --> Column A --> Cell 2 thru (varies - can be hundreds or thousands)

Dataset 2
Workbook 2 (Rlistsort) --> Worksheet 1 --> Column A --> Cell 2 thru (currently 250 but will continue to increase)

Need to compare Column data in Workbook 1 to Data range column in Workbook 2. Cells containing matching data in Workbook 1 need to have that Row(s) deleted.

I am pretty new to Excel macros, sorry if this description is confusing. Any help is appreciated. I have read countless forums and mind-numbingly tried to combine different macro code to no avail.

Thank you.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

M
  • Solved
Comparing two columns on different sheets and deleting the entire row if any cell is different
Replies
9
Views
327
Logit
Logit
T
  • Question Question
Compare spreadsheet/worksheet with changing rows
Replies
2
Views
317
BenW71
B
N
  • Question Question
Spitting every 2000 rows of data to new workbook based on duplicate value
Replies
1
Views
77
Skyybot
Skyybot
A
  • Question Question
Proper syntax for finding duplicates comparing two columns in two sheets
Replies
1
Views
261
AtariBaby
A
H
  • Question Question
Using XLOOKUP in VBA to lookup value underneath specific header name (columns can change depending on worksheet)
Replies
0
Views
64
Hailee994
H

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top