Move text in cells via Checkbox tick

[Malcolm torishi]

Hi I can anyone help please
i have 2 worksheet, worksheet 1 has all patients names in column A2 - A22 and address in B2 -B22. In column C I have a checkbox alongside each name/address. What I want to do is tick the checkbox and the name and address of the person on that row will move to worksheet 2 and and move the names up on sheet 1 so there are no blanks. And if i tick another checkbox another that name will drop under the other name on sheet 2

 

[Malcolm torishi]

Hello I just want to come back to you and let you know that I have used your VBA Code and that it has help me sort out what I wanted to do. Thank you so much very appreciated

 

[My Aswer Is This]

Hello I just want to come back to you and let you know that I have used your VBA Code and that it has help me sort out what I wanted to do. Thank you so much very appreciated

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[Malcolm torishi]

Hi
the vba code you have suggested works brilliant and does everything other than one thing that I now need it to do. That is , when I double click on the cell to delete a range on that row, can the code delete, say 2 ranges on that row. eg leaving a column with the middle of a range that as a formula in thus leaving the formula rather than being deleted.