Hi All!

I'm looking for some VBA code that fulfils the following:

On Sheet1, each row has a check box in Column A. If a checkbox is checked from Column A, it's corresponding Row copied to Sheet2 when a button is pressed.

The other Columns on Sheet1 do not have check boxes in them, only certain columns (B, C, F, G, O, P) are to be copied to Sheet2 when the button is pressed.

When copying to Sheet2, the gaps in-between the Columns should be deleted.

Thanks in advance,

Joe

EDIT: I have tried using code from previous threads, but cant seem to make it work!