im setting up a spreadsheet system for as IT.

i have a series of rows, and at the end of each row theres a checkbox,
linked with a cell, which is either true or false. i also have a button
which, through macros, i would like to be able to delete all the rows that
are checked, by just clicking the remove button.
a) is this possible
b) can i then move all the remaining data up so there are no empty rows,
c) can someone please tell me the visual basic editor for this!

thankyouxxx