delete value on worksheet 2 that match values on worksheet 1

N

np

Is there a way to delete rows in worksheet 2 that match the values in
worksheet 1 through some excel feature or programatically? For example my
worksheet 1 has about 10000 row of data. I need to file the matching rows in
worksheet 2 and elimiate those rows in worksheet 2.

thanks
nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel macro to copy rows in one sheet and insert into another sheet 5
Can the IF function be used with values from multiple worksheets? 4
Delete values in sheet 2 that arre found in sheet 1 1
Word macro that can call cells out of Excel for a find and replace 0
Matching Rows with Multiple Columns in Two Worksheets 0
Auto deletion of cell entry in given circumstance 0
How to insert new worksheet based on # of rows in a data sourch 2
Transpose 1

Top