remove uniques between sheets

[emukiss10]

Hello,

- Sheets(1) column F from F2 to FXXX has some numbers
- Sheets(2) column E from E2 to EXXX has some numbers

I need to remove all rows in Sheets(2) based on those numbers (E) that are not present in Sheets(1) (F)

Please Help with VBA

Best Regards
W.

 

[hiker95]

I need to remove all rows in Sheets(2) based on those numbers (E) that are not present in Sheets(1) (F)

emukiss10,

Can we see examples of the numbers in Sheets(1) column F?

Can we see examples of the numbers in Sheets(2) column E?

 

[emukiss10]

Sorry sir, unfortunatly no. Security reasons. Different numbers, different length in both columns. Only numbers. If match do nothing, if does not match - remove.

What data do You need?

 

[BGY23]

All numbers in both columns MUST be the same format.

=in D2 sheet 2 =VLOOKUP(E2,Sheet1!$F$2:$F$xxx,0) copy down to cover all rows in sheet2 #Value means that number is not on sheet 1. Apply a filter on #Value and delete all the rows.

 

[emukiss10]

Thank You but I need macro. I can do it with formula but that is not the point

 

[hiker95]

Sorry sir, unfortunatly no. Security reasons. Different numbers, different length in both columns. Only numbers. If match do nothing, if does not match - remove.

What data do You need?

emukiss10,

I always like to see what I am working with.

If you can not display just the numbers, then, I can not help you.

 

[emukiss10]

I dont understand

In column F Sheet(1) I have numbers like


A F
1| 009998885

2| 1234567890

3| 12233445566

4| ....

5| etc

If E2 Sheet(2) do not appear in F:F Sheet(1) - remove row 2 Sheet(2)
If E3 Sheet(2) do not appear in F:F Sheet(1) - remove row 3 Sheet(2)

and so on.

The numbers are mostely 9 digits but not always.

Nothing secial about it
Format : General

 

[yosegmail]

use this formula
{=IF($E$2:E='sheet1'!$F$2:F,'sheet1'!$F$2:F,"")}

 

[hiker95]

I dont understand

In column F Sheet(1) I have numbers like


A F
1| 009998885

2| 1234567890

3| 12233445566

4| ....

5| etc

If E2 Sheet(2) do not appear in F:F Sheet(1) - remove row 2 Sheet(2)
If E3 Sheet(2) do not appear in F:F Sheet(1) - remove row 3 Sheet(2)

and so on.

The numbers are mostely 9 digits but not always.

Nothing secial about it
Format : General

emukiss10,

If you can display sample numbers in Sheet(1), above.

Then, why can you NOT display the numbers in Sheet(2)?

 

[emukiss10]

The formating is the same.

Numbers are the same or are not. I dont know how can I describe it more accurately.

If in sheet 2 in column E row 9 is number 123 and it is not present in column F sheet 1 than remove this row form sheet 2. Remove uniques. How can I describe it more specidically?

It need to be exact match. 123 = 123 not 1234 nor 00123003

Im sorry If I cant do it better.