compare, if ID column empty copy the row to the new sheet

[Mariana]

Hello,
Can some one please help me with a macro that does this.I have a sheet and i need to compare the first 2 columns and if the second one is empty than copy row to a new sheet ,
Thank a milion
The column look like this
A B
InternDB ID
435622
563882
435535
dont copy if i both are numbers the sheet has over 800 rows
2324424 3424242

 

[Peter_SSs]

Mariana

Do you really need a macro? Could you use AutoFilter, filter column B to 'Blank', select all the (visible) data and copy and paste to the other sheet?

 

[Mariana]

hi there,
yes i think i need a macrobecause it is a part of an bigger project but i am not sure if it is possible please give me a macro or if you can explain to me how can i do it more eazy i will try that too,
thank you

 

[Peter_SSs]

Any more help out there on this one?

Doesn't look like it should be too hard for you VBA gurus. Or any other non VBA suggestions.

 

[Mariana]

thanks

thank you ,now it is allready resolved.Thank for care