Fill Out a Column automatically

[shlomek12]

Fill Out a Column automatically

Can the following be done

https://www.screencast.com/t/PAffxEfXZ

I would like to have a Macro/VBA to do it for the complete column

Thanks in Advance

 

[My Aswer Is This]

I would like for you to tell me in words what you want.

 

[shlomek12]

Fill down till the next line the prices

Right now I have to fill it out manually

Is the clip not much more clearer?

 

[My Aswer Is This]

I never like clicking on links. Your explanation is still not clear to me what your wanting.
You gave no specific details.
Like sheet names column numbers etc.
But maybe someone else here at Mr. Excel will click on your link and see your image and understand what your needs are.

Not sure what fill down to next line means.

Are you saying if you enter Cat in a cell you want cat also entered into below cell.

 

[Fluff]

How about

Sub FillDownPrice()
   With Range("[COLOR=#ff0000]Table1[Price][/COLOR]")
      .SpecialCells(xlBlanks).FormulaR1C1 = "=r[-1]c"
     [COLOR=#0000ff] .Value = .Value[/COLOR]
   End With
End Sub

Change table & column name to suit.
If you don't want hard values remove the part in blue

 

[shlomek12]

Thanks for your help

What to you mean by "Change table & column name to suit."

my Sheet is called "Sheet1" & it's in column E with The hadder of the column is "Price"

There is no table