Custom or Conditional Column to Copy data to Null Cells

SAMCRO2014

Board Regular
Joined
Sep 3, 2015
Messages
141
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?
 

Forum statistics

Threads
1,077,827
Messages
5,336,611
Members
399,092
Latest member
jbwatkins

Some videos you may like

This Week's Hot Topics

Top