Locking a one row description in Col A to a 4 row text in Col B, for sorting purposes

[jbclem]

I'm using an Excel 2002 spreadsheet to keep notes...Column A has the category description; Columns B, C, etc... have text(notes) associated with the category. The problem is that the Col A category description is usually one word (ie Computer, Internet, Politics) on one row, and the particular text associated with that phrase often occupies more than one row. Since I
have many categories, and repetitions of them, I want to be able to sort Col A alphabetically and have the text in the related Columns (B,C, etc...) be locked to the category in Col A so that the text will also sort along with it's related category description. Is this possible in Excel?


It's a very useful way to jot down notes and things I want to remember, and be able to access easily. But I need to be able to alphabetize the categories to make it easier to find things because the spreadsheet is getting too long.

Any ideas about this...?


John

[JBeaucaire]

Post a sample sheet showing all the problems you're trying to solve.

[jbclem]

I tried pasting in an example of what I was talking about, but the forum software made it impossible to get it right...it bunched up the columns. I tried for 20 minutes to make it work then gave up. The example is in the newsgroup message I originally posted (but no response so far), microsoft.public.excel.misc and the message was posted on 11-11-08 with a title similar to the one I used with this message.

I don't know how else to do it; but I think my explanation is pretty clear.

John

[JBeaucaire]

Hehe. you need to learn how things work. If you click on the QUOTE button for this message, look at how the next section is formatted:

Please Login or Register  to view this content.

Clear as mud?