Duplicating cells - question

J

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
 
S

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.
 
R

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.
 
J

jmcclain

Sean,

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

Again, thanks
 
G

Gord Dibben

Enter SPFL001 in A1

Right-click the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP
 
Top