I have a sheet1 with a list of employees and a check box control for each that is true if this is an active employee.

On sheet2, I'd like to press a command button and copy just the active employees from sheet1 to a new row for each active employee on sheet2. I'd like the rows created to begin at a specific point like, say, row 25.

Sheet1's columns a1, b1 and c1 contain Name, pay rate and 'active' (checkbox) respectively.

I'm new to excel but not to coding and I'd appreciate any guidance.

Thanks,
Tom