Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
List sort - filter macro based on check box | Excel Discussion (Misc queries) | |||
Formula Based On a Check Box | Excel Worksheet Functions | |||
Conditional Formula Based On A Check Box | Excel Worksheet Functions | |||
I want to return a value based on the status of a check box. If . | Excel Worksheet Functions |