copy paste row to another sheet then down 1 then repeat

[bert_da1]

hi i need help cleaning up all the code in my worksheets as i have tried lots over the last week to try and copy the rows on one sheet to another.
copy paste from "database" to "dismantle record" without over writing the data there, but paste it to the next row down creating a record of the database.
I also left lots of code in there as i have been copy and pasting bits of code trying to fathom it out.
Also i need to make a chart from certain columns of information on a new sheet so when the data is recorded a chart is created on another sheet.
The copy paste row is the main thing and the chart is a seperate issue from 4 or 5 columns of information.
Any help will be very much apprechiated.

[Palmetto]

It would be best if you uploaded a sample of your workbook (scrubbed of any sensitive data).

What is the criteria for copying? When do you want it to occur?
Please provide more details.

[bert_da1]

hi i need it to copy everytime one row is filled in on a sheet to clone it to another sheet on a different row, also it would be cool if i could search one of the cells for the word replace and if it is present copy that entire row to a different sheet for a record of replaced items
i will try to upload the sheets i have later o.k

Also how do i find my posts i used search and typed both threads and posts and put my name in but nothing was found it took me ages re finding them ?