Delete duplicate match from compared sheets

J

journey

New Member
Joined
Aug 10, 2011
Messages
8
Hi I need some help on how to create a celled formula or maybe a best method to create a macro in the following problem:

Sheet 1 has 6 digit data which is numeric and alphanumeric scattered in
various columns and rows.

Sheet 2 is the input data from the user.

Action: I want to be able to compare the user input data in Sheet 2 to Sheet 1 and find a duplicate match on Sheet 1.

If a match is found on Sheet 1, I want it to automatically delete the match found on Sheet 1.

Can someone please help?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
journey said:
Hi I need some help on how to create a celled formula or maybe a best method to create a macro in the following problem:

Sheet 1 has 6 digit data which is numeric and alphanumeric scattered in
various columns and rows.

Sheet 2 is the input data from the user.

Action: I want to be able to compare the user input data in Sheet 2 to Sheet 1 and find a duplicate match on Sheet 1.

If a match is found on Sheet 1, I want it to automatically delete the match found on Sheet 1.

Can someone please help?
Click to expand...

Is the input data from the user a single cell? If so which cell?
 
Upvote 0
The input data is from a row of cells.

example:

adc123
adc123
qrs345
kjc345

need to delete or clear the first found match from other sheet
If in the input data has another say: adc123

clear the next found match.

Thank so much.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Remove Duplicates from previous or multiple sheets.
Replies
7
Views
304
Benji3899
B
D
  • Solved
SUM of Columns based on multiple criteria with User Form
2
Replies
15
Views
332
Alex Blakenburg
A
J
  • Question Question
Duplicate Sheets in Excel VBA Project
Replies
1
Views
199
jkpieterse
jkpieterse
D
  • Solved
Date Issues with User Forms
Replies
4
Views
205
dmt32
D
R
  • Solved
Actively Copy Cells From Multiple Worksheets
Replies
8
Views
231
Ryusui
R

Forum statistics

Threads
1,224,522
Messages
6,179,297
Members
452,903
Latest member
Knuddeluff

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