Conditional Move Between Worksheets

Hi,

I am a novice with VBA and need to copy & paste rows from one sheet (Live) to another (Closed) depending on the condition that the value in column D is "Closed".

I have tried a few suggestions posted online but whenever I run them it only keeps the last entry and over-writes any previous data on the Closed sheet, whilst I need to retain all data.

I also need this to loop to check for multiple entries and move accordingly.

Just to complicate matters I have to keep the formulae in columns G & H of the Live sheet, so cannot simpy cut them across, which I assume would have been easier(?).

I've inlcuded a basic version of the sheet with a few examples which may show what I'm trying to achieve.

I am losing my mind trying to find a solution to this, so any help would be great!

Thanks!
John.

Dear jonnyseaweed,

best way to learn VBA is, record the macro for the activity what you want to do, for example, u wanted to copy a row from one sheet to another. record that..

then analyze the code and modify as required..