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.