Duplicating cells - question

[jmcclain]

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

 

[Sean Timmons]

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.

 

[RagDyer]

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.

 

[jmcclain]

Sean,

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

Again, thanks

 

[jmcclain]

Wonderful...learned something new today.

Have a wonderful weekend.

 

[RagDyer]

Appreciate the feed-back.

 

[Gord Dibben]

Enter SPFL001 in A1

Right-click the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

 

[Excel_Learner]

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

Appreciate the feed-back.