1) It doesn't appear to be pulling all the data (there is more that is grouped and hidden on the right side
It is copying the entire row per my testing, including when grouping is collapsed.
2) Its pulling the data as soon as I make the X which means if there is a mistake made you have to manually go in and delete that line every time.
This is what you asked for per your initial post.
The way I almost envisioned it was to have a little button on the bottom that when you hit GO it starts up the macro and pulls the entire rows.
How about using a double-click in the "X" column? Code below.
Also, cosmetically, I wondered if there was a way to automatically pull the header as well when that "Go Button" is hit.
Just manually copy the one row to the target sheet. Once it is there, no need to copy each time.
See attached.
Bookmarks