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.
Bookmarks