VBA for when drop down menu = Closed, cuts entire line and pastes to another sheet

[ManateeProfanity]

Hi guys,

I have a sheet called 'Action Register' which in column G has a drop down, which I would like to Cut the entire line when = 'Closed' and paste to sheet 3 which is called 'Closed Decision Register' starting at cell A4 across and down as it progresses.

Have found other sources and tried to adjust them but none of them seem to work for whatever reason! Thanks in advance

[BadlySpelledBuoy]

Maybe this in the Action Register sheet module will get you pointed in the right direction.

Please Login or Register  to view this content.

You mention you want the data to paste into row 4 and downward so it assumes you have headers in row 3 and that column A will always have a value.
It can be amended easily if any of those assumptions are incorrect.

BSB

[ManateeProfanity]

Thanks mate!