Moving data selected from one sheet to other and deleting empty cells

[mattkng]

Hi All,

So I'm pulling my hair out trying to figure out how to move/copy the data that is selected with the check box from sheet 1 to sheet 2 (see Pics) then move the data up deleting the empty cells on sheet 2. I've tried just using a simple excel if statement, but when I do that coupled with code to delete cells I lose the If statement for future use. I have tried VBA if statements with range().copy, but I'm not sure how to get it to just copy the check boxes (Col AC = true) values only, then remove the blank cells on sheet 2. I've found several thing that will delete the row, but I need to just delete the cells as there is hidden data that will mess up other formulas if deleted. Thanks in advance for the help.

 

[Micron]

This would be simpler if you went by True or False in column C rather than trying to locate what row a checkbox is in. It is possible to select cells, copy to another location and then delete source cells, choosing to shift adjacent cells up, left or whatever. The rest of your post makes no sense to me. I see no connection between what's supposed to be copied from 1 to 2 as 2 is blank. The column header in 2 doesn't match anything in 1 either. Nor do I see how there would be blank cells on sheet 2 either after copying rows 4,8,13,22,28 from sheet 1 to sheet2
Post 4 here might help you find checked checkboxes if you want to stick with that idea

Select Rows on click of a CheckBox

Dear Sir/Madam, I'm having a Simple yet difficult problem which I can't figure out. I'm still a self learner of macro. My doubt: I have a Table where 5 column and many rows are there. All row of Col-A have a CheckBox (I added it from Developer Tab). Col-B, Col-C, Col-D and Col-E has value...

www.mrexcel.com