dinostatic
08-18-2011, 01:31 AM
Hi,
First I'd like to apologize in advance for my "noob-ness," in all honesty I don't know a whole lot about VBA, but that's why I came here to seek help (:
Is there any way I can make a macro that automatically creates an outline based on a cell's value in that row? I'm working with excel 2003, and I have a whole lot of data that's been imported in a "tree like" hierarchy. It's color coded, but the auto-outline feature doesn't seem to outline it quite right. There is a column called Level that indicates the level in the tree of the item from 0 to 8. Is there a way I can use this, or the color of the row, to automatically group items and create an outline?
Any help would be appreciated. Thank you very much.
First I'd like to apologize in advance for my "noob-ness," in all honesty I don't know a whole lot about VBA, but that's why I came here to seek help (:
Is there any way I can make a macro that automatically creates an outline based on a cell's value in that row? I'm working with excel 2003, and I have a whole lot of data that's been imported in a "tree like" hierarchy. It's color coded, but the auto-outline feature doesn't seem to outline it quite right. There is a column called Level that indicates the level in the tree of the item from 0 to 8. Is there a way I can use this, or the color of the row, to automatically group items and create an outline?
Any help would be appreciated. Thank you very much.