Duplicating cells - question
 

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Right-click on your tab. Assuming the tab name is Sheet1:

For I = 2 to whatever
Worksheets("Sheet1").Cells(1,i).Value = "SPFL00"&i
Next I

should get it.

"jmcclain" wrote:

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Just enter the string in A1.
Hover the cursor over the lower right-hand corner of the cell until it
changes from a fat white cross to a skinny black cross.

Then, just click and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Sean,

Do I enter this after clicking "view code"?
Do I enter all 3 lines noted below.

Again, thanks

"Sean Timmons" wrote:

Right-click on your tab. Assuming the tab name is Sheet1:

For I = 2 to whatever
Worksheets("Sheet1").Cells(1,i).Value = "SPFL00"&i
Next I

should get it.

"jmcclain" wrote:

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Wonderful...learned something new today.

Have a wonderful weekend.

"RagDyer" wrote:

Just enter the string in A1.
Hover the cursor over the lower right-hand corner of the cell until it
changes from a fat white cross to a skinny black cross.

Then, just click and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
Wonderful...learned something new today.

Have a wonderful weekend.

"RagDyer" wrote:

Just enter the string in A1.
Hover the cursor over the lower right-hand corner of the cell until it
changes from a fat white cross to a skinny black cross.

Then, just click and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value
in?

Any help is appreciated.

Jon

Duplicating cells - question
 

Enter SPFL001 in A1

Right-click the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Fri, 26 Sep 2008 14:34:03 -0700, jmcclain
wrote:

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon

Duplicating cells - question
 

just enter
="SPF00"&row(1:1)
and drag it.

"RagDyer" wrote:

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
Wonderful...learned something new today.

Have a wonderful weekend.

"RagDyer" wrote:

Just enter the string in A1.
Hover the cursor over the lower right-hand corner of the cell until it
changes from a fat white cross to a skinny black cross.

Then, just click and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value
in?

Any help is appreciated.

Jon