LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default Locking a one row headline in Col A to a 4 row body of text in Col B?

I'm using a Excel 2002 spreadsheet to keep notes and Column A has the category phrase, Columns B, C, etc... have text
associated with the category. The problem is that the Col A category phrase 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 go along with the sort. Is
this possible in Excel?

Here's an example of what I mean:

A B C
================================================== ========
Politics blah blah blah blah blah
more blah blah blah blah
blah blah blah

Internet blah blah blah blah
blahblah blahblah blah blah

Computer yes yes yes yes yes yes maybe,yes yes yes yes
nonononononoblahblah why not, maybe, if, but
blahblah, blahblah blah

Internet okokokokokokokok yesterday,today,manana, aujourdhui
okdokyokdokywhatever

Computer dell,yahoo,google,mahimahi,tarzan,jane,silver,alas ka,moose,winkwink
hoje,ontem,amanha,sabado,domingo,hier,byebye,ciao, chow,woff,meow


Internet day-o,da-a-a-a-a-a-a-ay-ay-ay o
daylight come n me wanna go home

==========================================
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Headline with macro's disappears Palle korsholm Excel Discussion (Misc queries) 0 April 7th 08 02:13 PM
msg text body code for if then JC Excel Worksheet Functions 0 November 21st 07 03:46 PM
Trying to send an email with body text, to a range of cells [email protected] Excel Discussion (Misc queries) 1 November 29th 06 12:28 AM
Lookup in a list of number with a headline Traima Excel Discussion (Misc queries) 2 August 3rd 05 07:18 AM
Excel 2003 / Send To / Mail Recipient / body text is removed jmaynard2 Excel Discussion (Misc queries) 1 March 16th 05 02:26 AM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"