Populate specific cells from sheet 1 to sheet 2 with a checkbox and a button

[robv5712]

Hello all,

I'm hoping someone can help me out.
I have an excel sheet with 2 tabs - Data and Export.

I would like to copy specific cells from the Data tab to the Export tab.
But I only want it on certain rows.

Ideally I would like to have a checkbox on each row where I can select each row I want to export, I click a button, and the export tab gets populated w/ the cells from each row that is checked.
Also, is there an easy way to have that checkbox appear anytime I add a new row to the Data tab?
(attached)

Im going to start googling how to do this, but figured Id drop a question here as well to help save time.

Thank you so much for any help.

Rob

[karmapala]

If I'm not mistaken to get what you mean, my way is to create a userform rather than put checkbox on each row.

The UserForm has one ListBox which populated with a text representing the row number, like this :
Row 2
Row 3
Row 4
Row 5
and so on.

The user can select one item only in the ListBox,
can also select multiple items consecutively in the ListBox by dragging,
can also select mutliple items not consecutively in the ListBox by holding ctrl key in the keyboard while select the non consecutive item.

The code assumes that the data in Sheet Data has a header in the first row, so the data will always start in row 2 column A.