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 da...

excel

office 365

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.