Excel 2010 - Copy a Formula to every other cell in a column

I have an Excel spreadsheet that has a formula in cell C3 -- I would like to copy that formula down column C but in every other cell -- C5, C7, C9, etc.  Is there any easy way to do this?  Thank you
mmj1Asked:
Who is Participating?
 
Wilder1626Commented:
Hi

yes there is.

If your C3 as a formula in it and that C4 doesn't,  you can select C3 and C4, and use the drag square option to drag the formula every 2 rows.

Ex:
Select the 2 cells C3 and C4 and drag the small square down.  (see below picture)
Drag 1
Go down with the drag
drag 2
0
 
Martin LissOlder than dirtCommented:
Sub EveryOtherCell()

Dim lngLastRow As Long
Dim lngRow As Long

lngLastRow = Range("C1048576").End(xlUp).Row

Range("C3").Select
    Selection.Copy
'lngLastRow here can be change to any specific range/cell in column C
For lngRow = 5 To lngLastRow Step 2
   ' Cells(lngRow, 3).Formula = Range("C3").Formula
    Cells(lngRow, 3).Activate
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
Next

End Sub

Open in new window

0
 
Wilder1626Commented:
So you have 2 options, VBA macro or a drag formula.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
mmj1Author Commented:
That worked great!!!  Thank you.
0
 
mmj1Author Commented:
Thank you!
0
 
Wilder1626Commented:
I'm glad i was able to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.