macro to compare and copy data within 2 worksheets

[deepthi_goud]

i am dealing with two worksheets here. the first worksheet should check for a specified column(column name-AWN) and delete the entire row when that column is null.in the second worksheet i have the same column but only with few records. i have to compare 2nd sheet column values to 1st sheet and if matched in first sheet then entire row should be copied to second sheet.

i want a macro for this... please help...
thanks in advance

 

[Sathish KV]

Hi,

A loop procedure will do the trick but the last non blank row need to be identified

Can you upload a sample file with less data

 

[deepthi_goud]

Hi
Attached the sample file. the row count may be 'n' number.

 

[deepthi_goud]

The columns i specified are just for sample. the no.of columns may vary.

 

[Smallman]

Deepthi

Can you not put this formula in B2 of sheet2

=VLOOKUP($A2,Sheet1!$A:B,COLUMN(),0)

Drag this down and across and you should have your matches. Any NAs mean no match.

I would think this would be the most straight forward solution without getting VBA involved.

Take care

Smallman

 

[deepthi_goud]

Hi Smallman
Thank you for the solution provided. it worked well.
thanks a lot for your help.

 

[Smallman]

You are most welcome deepthi

Take it easy

Smallman