Excel Wizards,
I am trying to figure out how to organize a large spreadsheet as efficiently as possible.
Basically, I have a worksheet with URLs to my own articles, and potential forums where I might be able to share my expertise. I want to be able to sort the worksheet by the Topic, and have the corresponding information sort along with the topic. I also want to be able to group the information for each category (see attached), or by some other method collapse the data so the I can simply browse through the topics without the rest of the congestion. I have attached a worksheet with a basic skeleton of what I was thinking.
Overall, I want a condensed/collapsible spreadsheet that will sort by topic and bring corresponding information along with it.
Bonus: If I could sort by the largest # of articles or largest # of related forums that would be swell!
I tried sorting and using pivot tables, but then I ended up with blanks or unnecessary information. When I collapse the groups, I can't sort by just the topics without all of the data shifting around. If anyone has any suggestions as to how I can make sense of the spreadsheet it would be much appreciated! I know this might be confusing so please respond with any questions.
Cheers,
Tony
Bookmarks