Auto fill text columns based on rows
 

I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and
then repeat until the next section.

Any ideas on how to do this??

Thanks!!!

Column A Column B
Store Detail Competitors
Store 1
Store 1 Detail Comp 1
Store 1 Detail Comp 2
Store 1 Detail Comp 3
Store 1 Detail Comp 4
Store 4 Store 4 Detail Comp 1
Store 4 Detail Comp 2
Store 4 Detail Comp 3
Store 4 Detail Comp 4
Store 4 Detail Comp 5

Auto fill text columns based on rows
 

Select column A then F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

With column still selected, copy and in place, paste specialvaluesokesc.


Gord Dibben MS Excel MVP

On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia
wrote:

I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and
then repeat until the next section.

Any ideas on how to do this??

Thanks!!!

Column A Column B
Store Detail Competitors
Store 1
Store 1 Detail Comp 1
Store 1 Detail Comp 2
Store 1 Detail Comp 3
Store 1 Detail Comp 4
Store 4 Store 4 Detail Comp 1
Store 4 Detail Comp 2
Store 4 Detail Comp 3
Store 4 Detail Comp 4
Store 4 Detail Comp 5

Auto fill text columns based on rows
 

That worked!! thanks so much

"Gord Dibben" wrote:

Select column A then F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

With column still selected, copy and in place, paste specialvaluesokesc.


Gord Dibben MS Excel MVP

On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia
wrote:

I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and
then repeat until the next section.

Any ideas on how to do this??

Thanks!!!

Column A Column B
Store Detail Competitors
Store 1
Store 1 Detail Comp 1
Store 1 Detail Comp 2
Store 1 Detail Comp 3
Store 1 Detail Comp 4
Store 4 Store 4 Detail Comp 1
Store 4 Detail Comp 2
Store 4 Detail Comp 3
Store 4 Detail Comp 4
Store 4 Detail Comp 5

.

Auto fill text columns based on rows
 

Happy to help

Thanks for the feedback

On Mon, 29 Mar 2010 14:12:02 -0700, Cecilia
wrote:

That worked!! thanks so much

"Gord Dibben" wrote:

Select column A then F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

With column still selected, copy and in place, paste specialvaluesokesc.


Gord Dibben MS Excel MVP

On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia
wrote:

I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and
then repeat until the next section.

Any ideas on how to do this??

Thanks!!!

Column A Column B
Store Detail Competitors
Store 1
Store 1 Detail Comp 1
Store 1 Detail Comp 2
Store 1 Detail Comp 3
Store 1 Detail Comp 4
Store 4 Store 4 Detail Comp 1
Store 4 Detail Comp 2
Store 4 Detail Comp 3
Store 4 Detail Comp 4
Store 4 Detail Comp 5

.