PLACING SECTION NAMES IN A COLUMN

Eddie G. · Apr 24th, 2002, 02:24 PM

In column B, I have sections of similar data divided by a blank row between each section. I need a macro that will place a section name in column A at the top left of each section. The problem is each section name is different. Can this work:

LAX 1101
1101
1101

SFO 1241
1241
1241
1241

I want to place the LAX, SFO etc.

dhoffman · Apr 24th, 2002, 02:45 PM

whoa, whoa, whoa, are you sane man? This is a microsoft excel board, for COMPUTER STUFF, you know? kids shouldn't be playing around on here, it's annoying. Maybe your question just doesn't make any sense.

dhoffman · Apr 24th, 2002, 02:48 PM

I'm kidding, dumb joke, I know. I think I understnad what you want to do and it probably wouldn't be too hard to do. I hope these header names are already know and will be used in some sort of definite order? Or does the section data somehow say what the header should be? Are you familiar with VBA?

Eddie G. · Apr 24th, 2002, 02:50 PM

dhoffman: what are you talking about with this whoa whoa junk. It's a simple excel question. if i have like data in b1, b2, and b3 for example, i want to place a section name for that group of like data in cell a1 and so on down the sheet with the other like groups for data.

Asala42 · Apr 24th, 2002, 03:38 PM

Howdy,

I noticed your example has a pattern of "XYZ_####" - that is 3 letters, a space, followed by a 4 number code. Do your labels follow that pattern? or does the label have a title (like a varibly lengthed string?).

If you follow a strict XYZ_#### pattern then you could use this formula in ColA:

=IF(Isnumber(B2+0),"",Left(B2,3))

If your labels (like LAX) have more than 3 characters occasionally, use:

=IF(Isnumber(B2+0),"",Left(B2,Find(" ",B2)-1))

Is this something like what your looking for?

Adam.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 02:24 PM	#1
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	In column B, I have sections of similar data divided by a blank row between each section. I need a macro that will place a section name in column A at the top left of each section. The problem is each section name is different. Can this work: LAX 1101 1101 1101 SFO 1241 1241 1241 1241 I want to place the LAX, SFO etc.

Apr 24th, 2002, 02:45 PM	#2
dhoffman New Member Join Date: Apr 2002 Location: Lawrence, KS Posts: 29	whoa, whoa, whoa, are you sane man? This is a microsoft excel board, for COMPUTER STUFF, you know? kids shouldn't be playing around on here, it's annoying. Maybe your question just doesn't make any sense.

Apr 24th, 2002, 02:48 PM	#3
dhoffman New Member Join Date: Apr 2002 Location: Lawrence, KS Posts: 29	I'm kidding, dumb joke, I know. I think I understnad what you want to do and it probably wouldn't be too hard to do. I hope these header names are already know and will be used in some sort of definite order? Or does the section data somehow say what the header should be? Are you familiar with VBA?

Apr 24th, 2002, 02:50 PM	#4
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	dhoffman: what are you talking about with this whoa whoa junk. It's a simple excel question. if i have like data in b1, b2, and b3 for example, i want to place a section name for that group of like data in cell a1 and so on down the sheet with the other like groups for data.

Apr 24th, 2002, 03:38 PM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Howdy, I noticed your example has a pattern of "XYZ_####" - that is 3 letters, a space, followed by a 4 number code. Do your labels follow that pattern? or does the label have a title (like a varibly lengthed string?). If you follow a strict XYZ_#### pattern then you could use this formula in ColA: =IF(Isnumber(B2+0),"",Left(B2,3)) If your labels (like LAX) have more than 3 characters occasionally, use: =IF(Isnumber(B2+0),"",Left(B2,Find(" ",B2)-1)) Is this something like what your looking for? Adam.