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.
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.
