Forum Discussion

renae's avatar
renae
Copper Contributor
Jan 14, 2025

Fill Series with varying data

Is there anyway to fill a series when the data varies in column, I have to drag each value down and copy/fill, I would love it if there was a way to copy the series down, for example.  Grab all the cells and copy down 3630-301 into the next cell, but then 3630-302 into the 2 cells below that, 3630-304 into the next 6 cells below that and so on, if anyone has any thoughts.

 

 

excel

2 Replies

Sort By
  • renae's avatar
    renae
    Copper Contributor
    Jan 21, 2025

    Wow, thank you so much, this will save me hours of TIME!!!!!

     

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 15, 2025

    Select the column.

    Press F5 or Ctrl+G to activate the Go To dialog.

    Select Special...

    Select Blanks.

    Click OK.

    Note the address of the active cell in the selection. You should see this on the left hand side of the formula bar.

    Let's say it is G7 (just as an example).

    Enter the formula =G6 (referring to the cell above the active cell).

    Confirm the formula by pressing Ctrl+Enter.

Resources