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.