Code to copy nnon adjecent rows to another sheet

Hi all,

I am struggling with code that would allow a user to select non adjacent rows and move them to another sheet.

In essence, a user can select any cell in a given row (Lets say row B3), select another cell in another row (H7) from sheet 1 (There could be more cells selected), then click a button on sheet 1 and have Excel automatically copy and paste columns A to R from each line to the next available line on sheet 2.

The button already exists. just need the code behind the button.

Any help would be greatly appreciated as always.

Reg

Kev.

Select all your cells and try:

Please Login or Register  to view this content.

Thanks,

Worked a treat. I forgot to mention that i need to then delete the rows from sheet 1. I modified the code thinking this owuld work, but the last selected line does not delete.

Please Login or Register  to view this content.

sorted, used:

Please Login or Register  to view this content.

Glad it worked out.