|You will probably need to use a macro but we would need a lot more information about your task before we could offer any advice.|
e.g. What criteria? How does the "criteria" get entered into the column? Does the row get copied as soon as the criteria appears or are you trying to copy a bunch of rows of already existing data?
Please provide some more details.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.