Results 1 to 4 of 4

Thread: Custom or Conditional Column to Copy data to Null Cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2015
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Custom or Conditional Column to Copy data to Null Cells

    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?

  2. #2
    Board Regular
    Join Date
    Sep 2015
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom or Conditional Column to Copy data to Null Cells

    I figured it out. I am trying to make this harder than it needs to be

  3. #3
    Board Regular
    Join Date
    Nov 2016
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom or Conditional Column to Copy data to Null Cells

    Did it fill you up?

  4. #4
    Board Regular
    Join Date
    Sep 2015
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom or Conditional Column to Copy data to Null Cells

    Yes. I didn't realize it had that functionality. New to Power Query

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •