Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to Group Rows Based on Cell Contents
I receive a data extract that consists of several series of rows that
start with a Total Row followed by Detail Rows. The Details below each total row get grouped so that the user may hide or display them. The number of Detail Rows changes with each extract, so the grouping must be redone each time. I'd like to use a conditional formula that will deliver a "1" in the Total Rows, and a "0" in the detail rows. A macro would then refer to the column with the conditional formula and would group all rows with a "0" in that column, creating a new grouping between the "1's". And, the macro would stop when it hits a blank cell, which woiuld signify the end of the data extract. Note that I do NOT want to create subtotals for the rows, I just want to Group the rows that contain the details (with a "0" in my test field) as they occur between the rows with "1" in that field. If that's clear and anyone has code to accomplish this, I'd be most grateful. Feel free to post any questions if my objective is not clear enough. Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to unhide tabs based on cell contents | Excel Worksheet Functions | |||
hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
Run code based on cell contents | Excel Programming | |||
Code to hide rows based on cell contents | Excel Programming |