Macro based on check box
 

Hello,

I have a spreadsheet of prospects. Each prospect is 8 rows grouped.
There are approximately 100 prospects on a page.
In the grouped range, I want to put a checkbox or button or something
that selects that grouped range cuts it and moves it to another tab.
I want to have an individual checkbox/button for each prospect on the
list.

At this point I can add necessary columns / rows etc and have pretty
much free range to adjust the document as necessary.

I would like to write a macro that will grab the range that the
button/checkbox is in and move it, without haveing to rewrite it for
every prospect.

Can this be done?

Glen