Hi everyone I am new to programming and need some help with this problem.
This is what I need to do.
I have two sheets. "Sheet1" & "Sheet2"
On sheet1 I have a header that goes on every page rows 1 to 6.
On column A I have checkboxes.
I have data filled in from B7:Z7 from row 7 to 200.
What I want to do is go down the list and check all the checkboxes that needs to move to Sheet2.
Once I am done checking the boxes I want to be able to click a button that I create and move the checkboxes that are selected to the next available row on Sheet2. Then clear the data on sheet1 that was moved. So I can enter new data.
Any help would be greatly appreciated.