If it is a non equaiton you want copied, I would probably use a quick macro
similar to

sub fl()
for r = 4 to 25000
if cells(r,3)<"" then xx=cells(r,3) else cells(r,3)=xx
next r
end sub

"Greg" wrote:

I am trying to fill in certain information in a column using the cut/paste
function. Specifically Im copying the contents of cell C4 and pasting it
into C5:C7. Now in cell C8 there is a new text that needs to be copied into
C9:C15€¦ then new text in C16 etc etc.. The spacing varies greatly in how many
I have to paste but this repeats for about 25,000 lines or so. Does anyone
have a suggestion on how I can automate this? Please help!!
Thanks!