Move rows to new sheet on condition

i'm new to this and i am hoping someone can help.

im trying to re-vamp database managment procedures at work and have got stuck trying to use some functions of visual basic.

i am trying to move an entire row from a database on 'sheet 1' to the first empty row on 'sheet 2' dependant on column 'B' of 'sheet 1' containing an 'N'.

this may sound simple enough, but i have spent the last day and a half researching on the net, ironically greatly reducing my current poductivity, and getting nowhere.

macros thati have tried will move a row but each subsequent row will overwrite each previously moved row. agghhh.

any help will be greatly appreciated.

thanks for the input will give it a shot.

have just tried it and having the following problems:

macro will not run without being asked to from VBA interface
initially only sends rows 1-5 to sheet 2 (regardless of what row is given condition N in column 2)
subsequent transfer attempts only overlay on top of previous data

might just be being stupid somwhere but would be extremely greatful for any more advice.

cheers

i have ammended that as you asked.

thanks for that, your a gentleman.

Help!!!!

I've made some minor adjustments to my workbook and keep losing imformation.

If anyone can puzzle out my Visual Basic coding I would be most greatful.

Cheers.