VBA Code for Checking some Numbers between two Workbook & Highlight the same & also Delete the highlighted numbers with whole row.

[Bharath Kumar]

Hi There,

I have to prepare a report. for that I need a Macro which does the following method:

There are two workbooks namely A & B, A is the Tracker & B is the report what I have to prepare. So now I have to delete some column with full row which contains same numbers as in A workbook. The number would be like US20150518162044721. The given number will be there in B workbook also so Now I have to delete the entire row which is there in B workbook. The Number should highlight & Then should delete or directly should delete. Please help me out. Many Thanks in Advance...

 

[Bharath Kumar]

Help me out on this Buddies????

Hi There,

I have to prepare a report. for that I need a Macro which does the following method:

There are two workbooks namely A & B, A is the Tracker & B is the report what I have to prepare. So now I have to delete some column with full row which contains same numbers as in A workbook. The number would be like US20150518162044721. The given number will be there in B workbook also so Now I have to delete the entire row which is there in B workbook. The Number should highlight & Then should delete or directly should delete. Please help me out. Many Thanks in Advance...

 

[Cbrine]

Bharath,
Why not just use a vlookup to identify the values from A that exist on B, then sorted based on that vlookup, and delete the values that match?