Custom or Conditional Column to Copy data to Null Cells

SAMCRO2014

Board Regular
Joined
Sep 3, 2015
Messages
155
I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and do the same thing, and so on.

In VBA the coding would be:

'Copy cost centres in column A to blank cells above
With Range("A1:A" & LastRow)
.SpecialCells(xlBlanks).FormulaR1C1 = "=r[1]c"
.Value = .Value
End With

Do I need a custom column? I can't seem to getting the coding correct.

Any suggestions?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,090,135
Messages
5,412,669
Members
403,437
Latest member
Qwertyu

This Week's Hot Topics

Top