Creating a table of contents on a worksheet.......sortof like table of contents

Hi all,

I am trying to organize some "comments/things" and what i want to do is in cols A-F have like the table of contents and then in cols to the right have all the "stuff" that i am categorizing. The problem i found very quickly is lets supposed i want to "add" some information to one of my already exisiting categories.......well i can using insert rows to add the info but then my table of
contents where i manually entered row information is no longer valid..........any ideas? not too married to this approach so if you have better one i am open to that. or if you can figure out how i can add stuff but also have all my row information update properly let me know......i am enclosing a file to help show what i am trying to do.

Please Login or Register  to view this content.