Copy and paste range of data to next available row on different sheet

[Trae1170]

Hello everyone, I have a problem that hopefully one of you smart people can help me with.
I have a spreadsheet that is used for a "Action Tracker" (1st screenshot). In column F, if I choose from the dropdown and place a checkmark in the box, I would like the data in cells G, H, I and J to be copied and pasted into the next available row on a different sheet (screenshot 2) starting on A19, H19, J19 & L19.

Right now I have it directly transferring using a formula which works but if I have any rows on the first sheet that are not checked, then I have a gap in the data on the second sheet. I want VBA code so that whenever a checkmark is placed the data transfers to the next available row so there is no gaps.

The 2nd part, maybe not as easy would be if I "Unchecked" a box on the first sheet it would remove the data from the second sheet and automatically shift all of the data up to the next available row. This would be to continue to prevent any empty rows on the second sheet.

I am using Office360, I can provide the workbook if needed.

 

[NoSparks]

I am confused why the data that transferred is out of order on the Summary sheet?

Why do you consider it out of order?
The first row of data transferred will be at the top, the last row transferred will be at the bottom and in between will be the other rows transferred in the order they were transferred.

As for the rest, all I can say is it works for me.
The exact same code runs every time a column F cell changes.
Why it doesn't work for you I don't know.
I can't trouble-shoot an issue that I don't have and I'm not able to recreate what you say is happening.

 

[NoSparks]

Hello Trae1170,

While attempting to recreate the issues you have with this, and I'm not able to,
but did discover how easy it would be to get into other dysfunctional situations.

As my approach to this doesn't work for you I will remove the link to the file I was using
and believe this should be abandoned.

I know that is of no help at all and am sorry for the inconvenience caused.

Hopefully some other member will be able to provide a solution.

 

[Trae1170]

Not a problem, thank you for spending time and effort on this.