Forum Discussion

Barbara_123's avatar
Barbara_123
Copper Contributor
Feb 25, 2025
Solved

add different dates or codes in the same column.

HI there,

 

so I managed to get my pdf into excel, however I want to fill the gaps with the previous data. so, in one column I have a week's dates in different places and I want the date of each day to repeat in each column. Same with the code. How can I do this?

 

 

this is what shows in the excel sheet:

 

 

and this is what I want to achieve (without having to do it one by one):

thank you for any help

excel
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Feb 25, 2025

    Select the column with the dates.

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

    Click Special...

    Select Blanks, then click OK.

    Note the address of the active cell in the selection, in the name/address on the left hand side of the formula bar.

    Let's say it is A4. Enter the formula =A3, referring to the cell above the active cell.

    Confirm the formula by pressing Ctrl+Enter.

    Similar for the codes.

2 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 25, 2025

    Select the column with the dates.

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

    Click Special...

    Select Blanks, then click OK.

    Note the address of the active cell in the selection, in the name/address on the left hand side of the formula bar.

    Let's say it is A4. Enter the formula =A3, referring to the cell above the active cell.

    Confirm the formula by pressing Ctrl+Enter.

    Similar for the codes.

Resources